Row based Conditonal formatting

[Anonymous]

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, if it's "Testing" it needs to be Yellow, etc. There are total of 5 colors. How do I approach this problem? I know there is coumn based conditonal formatting in PowerBi based on Gradient, rule etc but I could't find row based formatting. Any help is appreciated! 

The output should be something this this in PowerBI

Thank you!

[V-lianl-msft · Accepted solution]

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.

[Anonymous]

just remove status from var row_select and you are good to go

[Anonymous]

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

[Anonymous]

In VAR ROW_SELECT, how do refreence the Status row? I don't see any option like select row

[Anonymous]

Use Status in var and refrence bcz it has all  row vlaues or you can put in a coloumn then move to rows

[Anonymous]

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]

@Anonymous I edited my first post to give a better idea of what I need. Thanks 

[Thejeswar]

Hi @Anonymous ,

The Issue is not very clear.

If possible, share the expected Output and give some more details on how the Status plays a role here?

[Anonymous]

This is the excel

And this is what I need in PowerBI

Thanks!