Forum Discussion
Requirement to dynamically roll up and down in a Matrix visual as per slicer selection
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.
1 Reply
- Greg_Deckler
Community Champion
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