Forum Discussion

nicolast29's avatar
nicolast29
Icon for Helper V rankHelper V
4 years ago
Solved

Matrix visual Row background color based on group row

Hi

After research i arrive to color the data base on the row with this artiche

 

 

https://community.powerbi.com/t5/Desktop/Conditional-Formatting-based-on-Row-Values/m-p/1942773#M739356<div> <div>but i did'nt understand how to color the row itself<div><li-image width="677" height="493" alt="Capture.PNG" align="inline" id="660546iACD342B0B22EF502" size="large" sourcetype="new"><div> </div></li-image></div></div></div>

 

 

But i want to make the same on the raw

 

Here my files

https://1drv.ms/u/s!AoqtZHsX4Bzvg_t-D8Jh1acx3_roPg?e=8J5dmR 

thanls

Need Help
  • nicolast29's avatar
    nicolast29
    4 years ago

    Hi

    Thanks

    Ok but i will loose the hierarchy that i created

    Is there a possibility in dax or else to do it ?

     

    Kings Regards

2 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    4 years ago

    nicolast29 , You can do conditional formatting in all columns in a table visual and get row conditional formatting.

    But In matrix you can not do conditional formatting on row /column(pivot)

     

     

    If needed

    How to do conditional formatting by measure and apply it on pie?: https://youtu.be/RqBb5eBf_I4

  • nicolast29's avatar
    nicolast29
    Icon for Helper V rankHelper V
    4 years ago

    Hi

    Thanks

    Ok but i will loose the hierarchy that i created

    Is there a possibility in dax or else to do it ?

     

    Kings Regards