We're giving away 30 tickets for FREE! Share your story, your vision, or your hustle and tell us why YOU deserve a ticket.
Apply nowWin a FREE 3 Day Ticket to FabCon Vienna. Apply now
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 picturemeasures
@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.
User | Count |
---|---|
13 | |
12 | |
8 | |
8 | |
6 |
User | Count |
---|---|
28 | |
19 | |
13 | |
11 | |
7 |