Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello All,
I have a scenario wherein I am using Table matrix and want to show conditional formatting if the show 2 numbers are greater than show 1 then show GREEN, if the show 3 data is lesser than show 2 data then show RED. Below is the sample table.
Please advice how to go about this.
Company Name | Show 1 | Show 2 | Show 3 |
ABC | 20 | 30 | 10 |
xyz | 10 | 20 | 30 |
Solved! Go to Solution.
Hi @nagaraj007 ,
Do you mean that "From 2016", "From 2018", and "From 2020" are measures?
If so, you can create the two measures like so:
Condition11 = IF ( [Measure 2] > [Measure], 1, 0 )
Condition22 = IF ( [Measure 3] > [Measure 2], 1, 0 )
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @nagaraj007 ,
You can try this:
1. Create measures.
Condition1 = IF(MAX('Table (2)'[Show 2])>MAX('Table (2)'[Show 1]),1,0)
Condition2 = IF(MAX('Table (2)'[Show 3])>MAX('Table (2)'[Show 2]),1,0)
2. Conditional Format.
Then, the Matrix shows like what you want.
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Icey,
I am unable to get the required solution as per the below query. I have a table as per mentioned below
ExhibitionName -----------------Table Name
Form2016---------------------------Show Name
Form2018---------------------------Show Name
Form2020---------------------------Show Name
Please advice.
Hi @nagaraj007 ,
Do you mean that "From 2016", "From 2018", and "From 2020" are measures?
If so, you can create the two measures like so:
Condition11 = IF ( [Measure 2] > [Measure], 1, 0 )
Condition22 = IF ( [Measure 3] > [Measure 2], 1, 0 )
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you very much for the help.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |