Forum Discussion
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!!
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
5 Replies
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.
- 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.
