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, 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!

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.

9 Replies

  • Thejeswar's avatar
    Thejeswar
    Super User
    4 years ago

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

      This is the excel

      And this is what I need in PowerBI


      Thanks!

       

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

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

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

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        4 years ago

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

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

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