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.
Hello! I need the community’s help to create a dynamic matrix table based on three separate timestamp “versions”: budget, forecast, and previous forecast. The way I’d like to set it up as that I want 10 different matrix tables on the page based on different business units but these business units will remain static. Then I would like 4 slicers on the page that will dynamically change the figures on the ten tables: fiscal year, fiscal quarter, current forecast version, and previous forecast version. On the rows, I need to show specific metrics that are calculated based on measures (revenues, costs, costs(%)/revenues, install base, costs / install base, repair volumes, repair volumes(%)/install base, etc . On the columns, I would like to show in the following order: budget, forecast, forecast/budget (based on a measure), and forecast/previous forecast (based on another measure). I have searched the forums looking for a solution but haven’t found anything. Does anyone know how to develop the model to create this kind of matrix based on these measures? Any suggestions and advice is greatly appreciated! Thank you!
You may try using SELECTEDVALUE and CALCULATE.
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 |
---|---|
114 | |
99 | |
83 | |
70 | |
61 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |