Forum Discussion
Conditional formatting per % spend share
Hi everyone,
Below my initial table.
Is it possible, with conditional formatting, to highlight the items, which make 80% of the spend share? (in the case of the table the items B and C)
| Items | Spend | Spend Share |
| A | 100 | 11% |
| B | 500 | 56% |
| C | 300 | 33% |
| Total | 900 | 100% |
Thanks for you support.
AleFVG , I think you have to create a Cumm % that in desc order.
See if the quick formula can help you in that.
Now on that Cumm % you have to create a measure like
if([Cumm %] <= 80 , "Red" , "black")
And use this in conditional formatting using field option.
Also, refer
https://blog.enterprisedna.co/implementing-80-20-logic-in-your-power-bi-analysis/
https://forum.enterprisedna.co/t/testing-the-pareto-principle-80-20-rule-in-power-bi-w-dax/459
2 Replies
AleFVG I think you would have to create a separate measure for that to base your conditional formatting on. Probably have to use RANKX and figure out what the bottom rank is that makes up 80% and then return 1 if the category falls into it or not. Something along those lines. If you can provide sample source data could be more specific.
AleFVG , I think you have to create a Cumm % that in desc order.
See if the quick formula can help you in that.
Now on that Cumm % you have to create a measure like
if([Cumm %] <= 80 , "Red" , "black")
And use this in conditional formatting using field option.
Also, refer
https://blog.enterprisedna.co/implementing-80-20-logic-in-your-power-bi-analysis/
https://forum.enterprisedna.co/t/testing-the-pareto-principle-80-20-rule-in-power-bi-w-dax/459
