Forum Discussion

kyrpav's avatar
kyrpav
Helper V
6 years ago
Solved

Custom conditional Formatting for matrix per row different threshold for same row by filter on table

Basically i want to have a table with commulative values for some months for some fields  that for each value i can control a conditional formating. The problem is that lets say like this:   We hav...
Need Help
  • v-deddai1-msft's avatar
    v-deddai1-msft
    6 years ago

    Hi kyrpav ,

     

    Currently, conditional formatting in matrix is based on all values of the matrix. You cannot apply it based on individual rows. Would you please vote for the similar idea in Power BI forum which has been submitted to improve Power BI and make this feature coming sooner.

     

    As a workaround, I suggest you create a calculated column like:

     

    Calculated column =  SWITCH(TRUR(),([Employee] = "Geogre" && Type = "Car1" && [salesamount] > 120K) ||([Employee] = "Geogre" && Type = "Car2" && [salesamount] > 200K),1 ,……………

     

    Then create conditional format based on the new column:

    For more details, please refer to https://www.cloudfronts.com/conditional-formatting-by-row-in-a-matrix/

     

    Best Regards,

    Dedmon Dai

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi kyrpav ,

 

Could you please show me your sample data(using a table is fine) and the result that you want(using an image or an excel screenshot is fine)?

 

Thanks.

Aiolos Zhao

kyrpav's avatar
kyrpav
Helper V
6 years ago

i changes a bit the main post to give you example cause the initial reply was exluded as spam

  • v-deddai1-msft's avatar
    v-deddai1-msft
    Community Support
    6 years ago

    Hi kyrpav ,

     

    Currently, conditional formatting in matrix is based on all values of the matrix. You cannot apply it based on individual rows. Would you please vote for the similar idea in Power BI forum which has been submitted to improve Power BI and make this feature coming sooner.

     

    As a workaround, I suggest you create a calculated column like:

     

    Calculated column =  SWITCH(TRUR(),([Employee] = "Geogre" && Type = "Car1" && [salesamount] > 120K) ||([Employee] = "Geogre" && Type = "Car2" && [salesamount] > 200K),1 ,……………

     

    Then create conditional format based on the new column:

    For more details, please refer to https://www.cloudfronts.com/conditional-formatting-by-row-in-a-matrix/

     

    Best Regards,

    Dedmon Dai