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 all
Is it possible to add a category that is not in the table?
i have data like below
and i want to display like below
A and B categories are month-to-date (MTD), and the C category is a fixed value regardless of the date slicer.
and result that i want is this
until now
1. user matrix chart -> row(categort), column(category2)
2. i made dax that display mtd and monthly total
Using DAX, it is possible to implement something like the 3rd picture??
Thanks all 🙂
Solved! Go to Solution.
hi @minseon ,
This is a dirty solution, if it works for you. Better doing it in Power Query.
hi @minseon ,
This is a dirty solution, if it works for you. Better doing it in Power Query.
User | Count |
---|---|
57 | |
46 | |
19 | |
16 | |
15 |
User | Count |
---|---|
116 | |
41 | |
40 | |
28 | |
22 |