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.
Have received a requirement to dynamically roll up and down in a Matrix visual.
In the Matrix, we are displaying 5 columns from a dimension in "Rows" Field in the Matrix visual. We have put a hardcoded slicer with names of these 5 dimension columns. This slicer is a multiselect. The requirement is to display Only the columns selected in slicer and thus roll up or down dynamically. Data model is created using Azure Analysis Services. Please suggest if you have any idea on how this can be resolved in Power BI or in data model or through DAX functions. Please let me know if you need more inputs on this.
Can you provide sample data nad expected output? Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
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 |
---|---|
12 | |
2 | |
1 | |
1 | |
1 |
User | Count |
---|---|
23 | |
3 | |
2 | |
2 | |
2 |