Forum Discussion
Background color conditional formatting
Same percentage range with different colors.
COLUMN 1 = 37,72% - yellow
COLUMN 2 = 37,5% (lower value) - orange
Both columns are defined with the same colors.
How do I set the values for both columns to maintain the same color scale?
@alan_ar You need to set low and high as 0 and 100, and choose an average value as well. Otherwise, Power BI will scale based on the data currently in that column. So change the LowestValue drop-down menu and enter the number 0 in the box below. Do this for the Medium and High values as well.
1 Reply
@alan_ar You need to set low and high as 0 and 100, and choose an average value as well. Otherwise, Power BI will scale based on the data currently in that column. So change the LowestValue drop-down menu and enter the number 0 in the box below. Do this for the Medium and High values as well.