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

Siddhesh_P's avatar
Siddhesh_P
Regular Visitor
2 years ago

To attain this objective, utilize conditional formatting that relies on the proportion of a measure's contribution to the overall total, rather than the raw measure itself. This ensures that the column formatting is determined by values always ranging between 0 to 1, as depicted in the image.

 

The dax for achieving this is as follows:

Month wise Qty Contribution =
Var _qty = [Qty]
VAR _total_qty =
    CALCULATE(
        [Qty],
        ALL('Calendar'[Month])
    )
RETURN
    DIVIDE(_qty, _total_qty)