Forum Discussion
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...
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.
You mean VAR ROW_STATUS = SELECTEDVALUE(Table_Name[Column_Name][Status]) ?
It gives me error.
I'm new to PowerBI so I'm struggling a bit. Can you write that code line please? Table name = Live_Overview, and the Column contaning Status row is named "Column1"
Anonymous I edited my first post to give a better idea of what I need. Thanks