Hey does anyone know how to write DAX to format based off of percent of totals?
The percentages would be :
Top 3rd = Green ( top 5 - 10 % )
Mid 3rd = Yellow ( mid 2 - 4.99 % )
Bottom 3rd = Red ( bottom 0.00 - 1.99 % )
Primary Model V 2.0 - Copy.pbix (20.9 MB)
I want to have the % of Totals highlighted based off of DAX that automatically highlights based off of the above.
Hi @michael.gyure - Can create a measure like below and use in Conditional formatting.
% Of Total Formatting = SWITCH(TRUE(),[% of Total] >= .5 && [% of Total] <= 1,"Green",[% of Total] >= .2 && [% of Total] < .5,"Yellow","Red")
Primary Model V 2.0 - Copy.pbix (20.9 MB)
Thanks
Ankit J
Hello @michael.gyure
Did the responses above help solve your query?
If not, can you let us know where you’re stuck and what additional assistance you need?
If it did, please mark the answer as the SOLUTION by clicking the three dots beside Reply and then tick the check box beside SOLUTION
Thank you