Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi All,
Need help with the below requirement. Want to show dynamic header names in a matrix or table based on my slicer selections that is year and month.
Thanks in advance
Regards,
KDR
@KDR , There are a few things here. for the measure(partial) on top, you can use the calculation group .
You will not be able to append the month name with a measure , so you need have month as one of the field in matrix column
Calculation Groups- Measure Slicer, Measure Header Grouping, Measure to dimension conversion. Complex Table display : https://youtu.be/qMNv67P8Go0
Thanks for the input. I have gone through the given link but it's not a feasible option for my problem.
My column header should change based on the year and month selection from the slicer.
Regards,
KDR
User | Count |
---|---|
98 | |
90 | |
78 | |
72 | |
65 |
User | Count |
---|---|
114 | |
97 | |
95 | |
68 | |
65 |