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.
Hi All,
I have set up conditional formatting on a Matrix table with 4 levels of rows, values has 2, revenue and the % of that revenue against the Row total...
Now I put the conditional formatting on this % field and set it 0-5% = Red 6-10% = Amber 11-100% = Green.
But whatever logic PowerBi is using its not making sense on the table, ie I have a row with 12% in the % field but its coming up as Red?
What does PowerBi work its Percentages off and is there a way to change this? or some alternative.
Thanks,
Solved! Go to Solution.
Hi @Anonymous ,
I create a simple sample that you could have a try. And you can use any of the values listed in the CSS color spec at https://www.w3.org/TR/css-color-3/ to color your visuals. In my sample, I use text to color it. Please view the sample below.
Conditional formatting =
SWITCH (
TRUE (),
'Table'[%] <= 0.05, "Red",
'Table'[%] <= 0.1, "Yellow",
"Green"
)
Best Regards,
Xue Ding
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @rgodavarthy ,
It is by design. The percentage is calculated based on Range.
Percentage(in conditional formatting)
You could try to create DAX formulas to apply that color to the background of font color of a table or matrix visual. For more details, you could try my sample.
Reference:
Best Regards,
Xue Ding
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you @v-xuding-msft this is really helpful!
I am struggling as to how to implement it though as I am not measuring against a goal but a % of the Row total in a Matrix so the only field I have is Revenue against millions of rows.
The Matrix looks something like this
Line of Business | Windows | Doors | Flooring | Total | ||||
Country | Rev | % | Rev | % | Rev | % | Rev | % |
UK | 25.1 | 51% | 11.4 | 23% | 13 | 26% | 49.5 | 100% |
France | 10.6 | 9% | 100.2 | 82% | 11 | 9% | 121.8 | 100% |
Germany | 30.1 | 44% | 18.9 | 28% | 19.5 | 28% | 68.5 | 100% |
Total | 65.8 | 27% | 130.5 | 54% | 43.5 | 18% | 239.8 | 100% |
There are sublevels below those in the matrix also going down at least 4 or more levels.
Thanks again for the help!
Hi @Anonymous ,
I create a simple sample that you could have a try. And you can use any of the values listed in the CSS color spec at https://www.w3.org/TR/css-color-3/ to color your visuals. In my sample, I use text to color it. Please view the sample below.
Conditional formatting =
SWITCH (
TRUE (),
'Table'[%] <= 0.05, "Red",
'Table'[%] <= 0.1, "Yellow",
"Green"
)
Best Regards,
Xue Ding
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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 | |
95 | |
80 | |
68 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |