Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply

Matrix Visual - Conditionally Format each Row for Different Measures

Hi,

 

I have a matrix table containing multiple measures on each row:

 

04.png

 

These measures are added to the matrix via on Switch Measure:

 

05.png

 

I want to be able to conditionlly format each row individually, based on separate criteria for each metric. For example, Media Reach would look at the highest and lowest numbers. Opportunity Won would look at this based on a target value and FYTD Vs PFYTD % would have 3 target bands.

 

Is there a way to set up a conditional formatting measure that would list each measure and the way to format it for each? Or woud there be an alternative method?

 

I've created a parameter table to group my metrics, so they appear accessible in this table. Otherwise I would have added each metric to the matrix individually, but I'd lose the ability to show Business Unit and Division this way. 

 

Thanks,

Mark

1 REPLY 1
danextian
Super User
Super User

Hi @Mark_Holland_GD 

This would be quite complex to achieve. For instance, if you're examining the highest and lowest numbers, you may need to rank the months for that specific measure row and individually assign a color to each rank. Additionally, you would need to create another set of conditions based on whether the percentage hits which target bands.

 

SWITCH (
    SELECTEDVALUE ( 'table'[order] ),
    0, SWITCH ( [separate rank measure], 1, "green", 2, "red", 3, "blue" ),
    1,
        SWITCH (
            TRUE (),
            [FYTD % Difference] >= 0.90, "green",
            [FYTD % Difference] >= 0.70, "yellow",
            "red"
        )
)

 










Did I answer your question? Mark my post as a solution!


Proud to be a Super User!









"Tell me and I’ll forget; show me and I may remember; involve me and I’ll understand."
Need Power BI consultation, get in touch with me on LinkedIn or hire me on UpWork.
Learn with me on YouTube @DAXJutsu or follow my page on Facebook @DAXJutsuPBI.

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.