Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hello community
I have a matrix with stores sales as rows and months as columns and I need to format the matrix cells based on the differences of sales between months, so if a store sales in Feb are higher than Jan, this cell should be colored with green, otherwise it should be red
I tried to apply solutions provided in this post:
Solved: Conditional formatting based on differences betwee... - Microsoft Power BI Community
but non of them worked for me
Thanks in advance
Solved! Go to Solution.
Hi @ivan_abboud ,
Assume you have a 'DateTable' :
1-Create this calculated column in 'DateTable':
YearMonthIndex = (DateTable[Year])*12+DateTable[Month]
2-Assume Your measure Name is [Sales]=SUM('Table'[SalesAmount]) . Create the measure below:
SalesPrevMonth=
CALCULATE (
[Sales],
FILTER (
ALL ( 'DateTable' ),
'DateTable'[YearmonthIndex]
= MAX ( 'DateTable'[YearmonthIndex] ) - 1
)
)
3-Then Create the measure:
SalesDiff=
[Sales]-[SalesPrevMonth]
4-Then you can set conditional formatting by the [SalesDiff] Measure. (Greater and less than 0 condition on it)
If this answer solves your problem, give it a thumbs up and mark it as an accepted solution so the others would find what they need easier.
Regards,
Loran
Hi @ivan_abboud ,
Assume you have a 'DateTable' :
1-Create this calculated column in 'DateTable':
YearMonthIndex = (DateTable[Year])*12+DateTable[Month]
2-Assume Your measure Name is [Sales]=SUM('Table'[SalesAmount]) . Create the measure below:
SalesPrevMonth=
CALCULATE (
[Sales],
FILTER (
ALL ( 'DateTable' ),
'DateTable'[YearmonthIndex]
= MAX ( 'DateTable'[YearmonthIndex] ) - 1
)
)
3-Then Create the measure:
SalesDiff=
[Sales]-[SalesPrevMonth]
4-Then you can set conditional formatting by the [SalesDiff] Measure. (Greater and less than 0 condition on it)
If this answer solves your problem, give it a thumbs up and mark it as an accepted solution so the others would find what they need easier.
Regards,
Loran
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
User | Count |
---|---|
91 | |
89 | |
79 | |
69 | |
68 |
User | Count |
---|---|
222 | |
128 | |
117 | |
82 | |
77 |