Forum Discussion
Row based Conditonal formatting
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.
writesomething similar as follow
Color Significance period new =
VAR vMaxSelected = [coloumnrefrence or measure]
RETURN
SWITCH(
vMaxSelected,
"declining", "red",
"inclining", "light green",
"stable","yellow"
then do conditional formation based on that measure
In VAR ROW_SELECT, how do refreence the Status row? I don't see any option like select row
Use Status in var and refrence bcz it has all row vlaues or you can put in a coloumn then move to rows
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