Power BI - Custom Conditional Formatting Measure
- or -
Post a project like this1137
£25/hr(approx. $31/hr)
- Posted:
- Proposals: 11
- Remote
- #3184952
- Completed
Data Modeling in Excel & Power BI With Power Pivot, Power Query, DAX and Google Data Studio Expert.
Dhaka
1603762664984194671421817363710886524416452531735416411542670355472195552826
Description
Experience Level: Expert
Hi, I am looking for someone to help me with a very simple yet challenging task.
I have a matrix table with headers and data similar to the following:
Item Jan 2020 Feb 2020 March 2020 April 2020 May 2020
1 3 5 6 6 3
2 1 3 1 5 1
3 0 5 3 2 2
4 10 12 5 1 4
5 5 3 2 0 4
I am seeking to hire someone to build a measure that can be used for conditional formatting where by the highest value in each row will have Colour A and Lowest will have Colour E (each row by row and not across the whole table), and middle values will have perhaps 3 middle colour variations B, C, & D. So results will look something like follows (highlight colour in brackets)
Item Jan 2020 Feb 2020 March 2020 April 2020 May 2020
1 3(E) 5(B) 6 (A) 6(A) 3(E)
2 1 (E) 3 (C) 1(E) 5(A) 1(E)
3 0 (E) 5 (A) 3(C) 2(D) 2(D)
4 10 (B) 12(A) 5(D 1(E) 4(D)
5 5 (A) 3(C) 2(D) 0(E) 4(B)
This is simply a conditional formatting measure to do conditional formatting row by row in MS Power BI.
Please share cost and example screenshot if interested.
I have a matrix table with headers and data similar to the following:
Item Jan 2020 Feb 2020 March 2020 April 2020 May 2020
1 3 5 6 6 3
2 1 3 1 5 1
3 0 5 3 2 2
4 10 12 5 1 4
5 5 3 2 0 4
I am seeking to hire someone to build a measure that can be used for conditional formatting where by the highest value in each row will have Colour A and Lowest will have Colour E (each row by row and not across the whole table), and middle values will have perhaps 3 middle colour variations B, C, & D. So results will look something like follows (highlight colour in brackets)
Item Jan 2020 Feb 2020 March 2020 April 2020 May 2020
1 3(E) 5(B) 6 (A) 6(A) 3(E)
2 1 (E) 3 (C) 1(E) 5(A) 1(E)
3 0 (E) 5 (A) 3(C) 2(D) 2(D)
4 10 (B) 12(A) 5(D 1(E) 4(D)
5 5 (A) 3(C) 2(D) 0(E) 4(B)
This is simply a conditional formatting measure to do conditional formatting row by row in MS Power BI.
Please share cost and example screenshot if interested.
Hisham F.
100% (4)Projects Completed
3
Freelancers worked with
3
Projects awarded
57%
Last project
9 Mar 2021
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies