Forum Discussion

PRodriguez's avatar
PRodriguez
New Member
9 years ago
Solved

Conditional Formatting Matrix Columns

Hello,   I am trying to figure out if there is a way to use conditional formatting to go on the basis of the column, rather than the entirety of the matrix.   For example, when I use the Lowest v...
Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    PRodriguez,

    Conditional formatting applies to a range of values in a single column of your original table, when you create a Matrix visual using fields of the original table, all values come from this single column,  thus conditional formatting goes on the entirety of the Matrix.



    The feature you describe can’t be achievable in Power BI Desktop, you can submit a feature request in the Power BI ideas forum: https://ideas.powerbi.com/forums/265200 .



    Thanks,
    Lydia Zhang

manuelbanza's avatar
manuelbanza
Frequent Visitor
7 years ago

Hello,

 

Does anyone know if there is already a solution for the question asked?

 

Thank you for your help,

Anonymous's avatar
Anonymous
Not applicable
7 years ago

I got around this by using the ALLEXCEPT() function a measure. This function will ignore all filters but one, so if you choose the column value as the exception you can use conditional formatting on a column basis.

  • lgroger's avatar
    lgroger
    Icon for Advocate I rankAdvocate I
    6 years ago

    Can you provide an example of how you did this? 

  • TorbenL's avatar
    TorbenL
    Icon for Advocate I rankAdvocate I
    6 years ago

    Anonymous I'm trying to figure this out as weel. Can you provide an example of how you managed to solve this by ALLEXCEPT?

     

    Best,

    Torben

    • AndrewJames's avatar
      AndrewJames
      Icon for Microsoft Employee rankMicrosoft Employee
      6 years ago

      Did anyone solve this issue?