The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
I have data in a matrix and I want to add an icon that shows if it is higher or lower than the previous row. It looks like the only option is to compare the individual row to the highest and lowest values over all.
Solved! Go to Solution.
I am assuming you have a measure that adds up the amounts in your table like.
SUM = SUM ( YourTable[Amount] )
And also that you have a dates table in your model. If so you can write a measure like this.
Change from Prior Day =
[SUM] -
CALCULATE([SUM],DATEADD(Dates[Date],-1,DAY))
Then use that in a conditional formatting rule on the [Sum] value in your visual.
Here is the result.
I am assuming you have a measure that adds up the amounts in your table like.
SUM = SUM ( YourTable[Amount] )
And also that you have a dates table in your model. If so you can write a measure like this.
Change from Prior Day =
[SUM] -
CALCULATE([SUM],DATEADD(Dates[Date],-1,DAY))
Then use that in a conditional formatting rule on the [Sum] value in your visual.
Here is the result.
This works! Thanks!
User | Count |
---|---|
75 | |
70 | |
39 | |
30 | |
28 |
User | Count |
---|---|
104 | |
95 | |
51 | |
48 | |
46 |