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.
Hi Sir,
How to compare raw count against category for two different dates in Matrix visual using conditional formatting. I have a matrix table where I am showing the volume like below for two dates and I want to highlight if the volume is increasing or decreasing using conditional formatting.
Category | 15-Aug-23 | 16-Aug-23 |
A | 45 | 35 |
B | 55 | 65 |
C | 57 | 68 |
Solved! Go to Solution.
You can create a measure like this , all i am doing is subtracking the current date from the previous date and if is less than 0 i give it a 1 else 0.. You can then use this measure to create your conditional format.
Prior Day Volume =
You can create a measure like this , all i am doing is subtracking the current date from the previous date and if is less than 0 i give it a 1 else 0.. You can then use this measure to create your conditional format.
Prior Day Volume =
User | Count |
---|---|
88 | |
88 | |
75 | |
67 | |
58 |
User | Count |
---|---|
136 | |
110 | |
91 | |
84 | |
69 |