Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
User | Count |
---|---|
15 | |
4 | |
2 | |
1 | |
1 |
User | Count |
---|---|
21 | |
3 | |
2 | |
2 | |
2 |