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.
Solved! Go to Solution.
Based on the Calculation I see, you can create some additional COLUMNS in the table either in Power Query or using DAX like below. This way you can have a Hierarchy for Cost / Expsense. You can add multiple levels by having more columns in the table. Then you can arrange them in the Matrix visual.
This way you will need only one Measure SUM('06 Costi'[Valor]) which will work at all the levels for drill down functionality.
Cost -> Fixed Cost -> awardmanagement expenses
You should create Hierarchy for the Cost / Fixed Cost / Expense.
This way you would be able to get the Total Cost and Drill / Filter to a specific expense type as well.
Would you mind to explaim to me how can I create a Hierarchy for the Cost, please?
Because when I create a calendar it's ok to have a Hierarchy, but for the Cost, I don't how to do.
Thank you!
Based on the Calculation I see, you can create some additional COLUMNS in the table either in Power Query or using DAX like below. This way you can have a Hierarchy for Cost / Expsense. You can add multiple levels by having more columns in the table. Then you can arrange them in the Matrix visual.
This way you will need only one Measure SUM('06 Costi'[Valor]) which will work at all the levels for drill down functionality.
Cost -> Fixed Cost -> awardmanagement expenses
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 |
---|---|
113 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |