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 there, I need some help. I am trying to create a matrix (multi-level visual) that has icons (R/A/G) to indicate whether the number went up or down from previous day.
My data table looks like this;
The result needed;
Been looking around for answers but have not found anything that helps my case.
Appreciate your help!
Solved! Go to Solution.
Hi,
Here is how to do this:
Data:
Dax:
End result:
If you don't want arrows on the first row change the dax:
Proud to be a Super User!
Hi @LouiseR ,
I have created a simple sample, please refer to it to see if it helps you.
Create 2 measures. To get the count value before today.
Measure =
CALCULATE (
MAX ( 'Table'[COUNT] ),
FILTER (
ALL ( 'Table' ),
'Table'[Region] = SELECTEDVALUE ( 'Table'[Region] )
&& 'Table'[AGEING] = SELECTEDVALUE ( 'Table'[AGEING] )
&& 'Table'[Date] < SELECTEDVALUE ( 'Table'[Date] )
)
)
Then compare the 2 results.
result =
IF (
MAX ( 'Table'[COUNT] ) = [Measure],
0,
IF (
MAX ( 'Table'[COUNT] ) < [Measure],
1,
IF ( MAX ( 'Table'[COUNT] ) > [Measure], 2 )
)
)
Then create the conditional formatting.
How to Get Your Question Answered Quickly
If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .
Best Regards
Community Support Team _ Rongtie
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi,
Here is how to do this:
Data:
Dax:
End result:
If you don't want arrows on the first row change the dax:
Proud to be a Super User!
Your solution is great, however in my Matrix visual - it is the sum of the count.
The results look weird and even if the numbers go up or down it doesn't change the icons/results.
Below is the image of the Data table as well.
Appreciate your help on this.
User | Count |
---|---|
48 | |
44 | |
19 | |
14 | |
14 |
User | Count |
---|---|
107 | |
57 | |
29 | |
20 | |
16 |