Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi all, I'm dealing with an issue here.
I have a matrix visual made by two columns from a dataset (as a Hierarchy) and some Dax Measures as columns.
Now they ask me to add some titles to those metrics, grouped by some business logic. These titles are objective questions that aren´t in a dataset, so I have to create a new table that displays the questions, the value metrics and the business domains columns as rows.
Here are some examples!
How can I achieve this in Power BI? Right now I'm using text boxes as titles of the columns but don't seems to be a good idea.
Thanks in advance!
Solved! Go to Solution.
@Fran_Morelli , calculation groups, you can use for that
refer my example here
Calculation Groups- Measure Slicer, Measure Header Grouping, Measure to dimension conversion. Complex Table display : https://youtu.be/qMNv67P8Go0
Is there a way to achieve this without using a third party program like tabular editor?
@Fran_Morelli , calculation groups, you can use for that
refer my example here
Calculation Groups- Measure Slicer, Measure Header Grouping, Measure to dimension conversion. Complex Table display : https://youtu.be/qMNv67P8Go0
User | Count |
---|---|
124 | |
108 | |
99 | |
62 | |
62 |
User | Count |
---|---|
137 | |
116 | |
102 | |
71 | |
61 |