Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

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.