The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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 |
---|---|
82 | |
82 | |
37 | |
34 | |
32 |
User | Count |
---|---|
92 | |
79 | |
61 | |
51 | |
51 |