Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi Experts,
i have column called Spend in $ Value (from biggest to smallest), i just need to have colored conditional formatting says these are the rows which are the 70% of the total,
example : if my total is 100 the 70% is = 70 and i have these value
1- 40
2- 30
3- 20
4- 10
so i need to get 40 and 30 to be highlighted
hint: i have measure by Total and by 70%
my real report pic below.
can you please advice me what to do in order to get it done?
thank you
Abdu
Solved! Go to Solution.
User | Count |
---|---|
128 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |