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...
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Here are some screenshot who should clear up what what I am looking for. I manipulated one value (the 27 at 16:00) to make my issue more clear.

 

The left Screenshot is the conditional formating I am looking for.

 

 

The left conditional formating is the result I am looking for but I have to define the values (max. and min.) in upfront.

The screenshot on the right is the conditional formating with the dynamic parameter I am lookig for but the result is not the right one.

 

  • 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.