Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Conditional Formating | Each Column - Separatly

Hello, I guess this should be a standard requirement but I cant find any solutions to this.   The case is pretty simple. I have dates (column), hours (Row) and lets say conversion as a value. I wa...
V-lianl-msft's avatar
V-lianl-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi Anonymous ,

 

Could you share the sample data?

In my tests, I don't need to set the maximum and minimum values to get the expected result.

 

 

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

First, thank you for the answer. It is not working in your example neather. Look at the first row, there is no max or min in this row, its just over all values.

 

As far as I see in your case PowerBI ist looking on all the data and distribute the color based on the highest and lowest color on all values. I want a color distibution based on each Colomun. This means a highest and lowest value on each column.

 

In my example sample I put an atificial very high value in the first day to show that PowerBI is calculating every value together. If Power BI had calculated each column separatly we had dark and light colors on every column.

 

And dont have the sample of data anymore but this is a problem I am often confronted with. Just put a very high value in one column and you should see the problem in your data.