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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
powerbi2srm
Resolver II
Resolver II

Conditional formatting row by row

I've created the following measure:

bank_sales_amount =
CALCULATE(

      sum(sale_order[sales_amount]),

      dim_activity_area[name] = "banks"

)

 

I've drag this measure to a table visualization. This visualization have geography (countries) as columns and months as rows.

 

I want to create a conditional color format to returns what are the best months for each row (geography).  For example, with this table I want to know through the color if april was a good month in Spain or if september was a good month in France

 

thank you!!

1 ACCEPTED SOLUTION

There is a similar solution here (I do recommend to read every replies):
Re: Row by row Conditional Formatting on a Matrix - Microsoft Fabric Community

View solution in original post

5 REPLIES 5
MFelix
Super User
Super User

Hi @powerbi2srm ,

 

For this you need to add an additional measure that makes your calculation identify the best month should be similar to this:

 

Colour coding =
VAR temptable =
    CALCULATETABLE (
        SUMMARIZE (
            sales_order,
            geography[countries],
            'Calendar'[Month],
            'Calendar'[Year],
            "_banksalesamount", [bank_sales_amount]
        ),
        ALLSELECTED ( 'Calendar' )
    )
RETURN
    IF ( [bank_sales_amount] = MAXX ( temptable, [_bank_sales_amount] ), "#000000" )

 

 

Replace the #000000 by the colour coding you want then use this measure has your condittional formatting.

 

This formula may need adjustment based on your model.


Regards

Miguel Félix


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

Proud to be a Super User!

Check out my blog: Power BI em Português



That code doesn't run because calendar, sale_order and dim_geography are different tables

How are the tables related?

 

Can you please share a mockup data or sample of your PBIX file. You can use a onedrive, google drive, we transfer or similar link to upload your files.

If the information is sensitive please share it trough private message.


Regards

Miguel Félix


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

Proud to be a Super User!

Check out my blog: Power BI em Português



This case that I'm looking for (there a are a pbix in replies). However, when I use that code and I filter by more than one year (in a slicer) I don't have the result that I expect: the code doesn't work properly.

https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Row-by-row-Conditional-Formatting-on...

There is a similar solution here (I do recommend to read every replies):
Re: Row by row Conditional Formatting on a Matrix - Microsoft Fabric Community

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.