Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hi
I'm trying to understand the maths behind the cell elements condtinal formatting rules see below
This has colour codes my values in the following way:
509 - Green
397 - Green
353 - Yellow
250 - Yellow
94 - Red
80 Red
Note - The field is a generic sales measure
Can anyone clarify the maths that leads to this result?
Many thanks,
Solved! Go to Solution.
Hi @Peppearson
My understanding is that percentages (in this dialog box) correspond to linear interpolations between the Min and Max values.
So the Value corresponding to a given percentage p is Min + p/100 * (Max - Min).
To put it the calculation in steps, using your figures as an example:
The icons are then explained based on where the values fall relative to these threshold values.
It might have been more intuitive if there was an option for percentiles, so that the smallest 33% of values could be given a certain format, and so on. You could still achieve this, but would need to write a measure to handle it.
Regards
Thanks for the explanation! Makes sense now.
Hi @Peppearson
My understanding is that percentages (in this dialog box) correspond to linear interpolations between the Min and Max values.
So the Value corresponding to a given percentage p is Min + p/100 * (Max - Min).
To put it the calculation in steps, using your figures as an example:
The icons are then explained based on where the values fall relative to these threshold values.
It might have been more intuitive if there was an option for percentiles, so that the smallest 33% of values could be given a certain format, and so on. You could still achieve this, but would need to write a measure to handle it.
Regards
User | Count |
---|---|
120 | |
69 | |
68 | |
57 | |
50 |
User | Count |
---|---|
166 | |
82 | |
68 | |
65 | |
53 |