Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Row based Conditonal formatting

Hi,    I have a table in excel in which one of the row "Status", needs to be color based background format in PowerBI.   For example, if it's "Development", it needs to be blue, i...
Need Help
  • V-lianl-msft's avatar
    V-lianl-msft
    4 years ago

    Hi Anonymous ,

     

    Unfortunately, your model does not support this. In power bi, there are relationships between columns, which are not independent of each other. It is difficult to format field with DAX formula in your model.

    Please try to transpose column1 in query editor.

     

     

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

V-lianl-msft's avatar
V-lianl-msft
Community Support
4 years ago

Hi Anonymous ,

 

Unfortunately, your model does not support this. In power bi, there are relationships between columns, which are not independent of each other. It is difficult to format field with DAX formula in your model.

Please try to transpose column1 in query editor.

 

 

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