Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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!!
Solved! Go to 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
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
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHow 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
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsThis 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.
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
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
71 | |
70 | |
38 | |
27 | |
26 |
User | Count |
---|---|
97 | |
96 | |
59 | |
44 | |
40 |