Forum Discussion
Measure hierarchy in matrix visual
Dear PBI community,
is there a possibility to define grouping / hierarchy of separately calculated measures to be shown in a matrix visual? I haven't found andy appropriate solution.
The desired state is shown in this table.
Thank you so much
| - Measure 1 Name | Measure 1 Value |
| -- Measure 1.1 Name | Measure 1.1 Value |
| -- Measure 1.2 Name | Measure 1.2 Value |
| -Measure 2 Name | Measure 2 Value |
| -- Measure 2.1 Name | Measure 2.1 Value |
| -- Measure 2.2 Name | Measure 2.2 Value |
| -- Measure 2.3 Name | Measure 2.3 Value |
| - Measure 3 Name | Measure 3 Value |
| - Measure 4 Name | Measure 4 Value |
ok, the editor is not showing it properly. See attached picture
measures
2 Replies
- amitchandak
Super User
Vosina , If all these are measures, then you need to convert them into dimensions.
Check if the tabular editor or calculation group can help. I doubt so.
calculation groups
https://www.sqlbi.com/blog/marco/2020/07/15/creating-calculation-groups-in-power-bi-desktop/Thank you Amit for your tip, I will check it out.
