Forum Discussion
Conditional formatting per % spend share
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
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