Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi everyone,
I have a table in my Power BI Desktop with a lot of calculated measures I have created. Many of them have some kind of relation, so it would be really helpful if there is a possibility to create some Hierarchies in the table that group the related measures.
Is this posible?
Thanks a lot!
Solved! Go to Solution.
What do you mean "have relation between measures"?
In Power BI Desktop, it's not possible to create a hierarchy/folder to group measures. You should create hierarchy on dimension members and only measure for corresponding fact data which can be sliced by the hierarchy. For example, you can create a calendar hierarchy like "Year->Quarter->Month->Date" to slice a Sales measure.
Regards,
Is this can be achieved on 2023?
You can group measures in specific tables.
1.- Create a blank query in the query editor.
2.- Rename it to something that makes sense to you like "Measures for Accounts" or "Average Measures"
3.- Move the measures to the corresponding tables by changing their Home Table in the modeling tab in Power BI Desktop.
That doesn't make measures hierarchies, but will let you group them in meaningful tables. Hope it helps.
What do you mean "have relation between measures"?
In Power BI Desktop, it's not possible to create a hierarchy/folder to group measures. You should create hierarchy on dimension members and only measure for corresponding fact data which can be sliced by the hierarchy. For example, you can create a calendar hierarchy like "Year->Quarter->Month->Date" to slice a Sales measure.
Regards,
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |