Forum Discussion

prachipriyam5's avatar
prachipriyam5
Regular Visitor
8 years ago

Dynamic column based on slicer selection

Hi,

 

I have a requirement where we want the users to have the flexibility to change the level of dimension dynamically.

Suppose we have dimension as below and Marks is the measure.

Department

Student

Class

Marks

Now, all the above dimension should be selected from the slicer. If the user selects Department , data should be aggregated by Marks and when user selects  department and Student then marks should be aggregated at Department and Student level. The view should look like as below

 

1st Selection View  2nd Selection View  
User SelectionDepartment User SelectionDepartment,Student 
      
DepartmentMarks DepartmentStudentMarks
Science100 ScienceAA150
Arts100 ScienceAA220
   ScienceAA330
   ArtsBB150
   ArtsBB220
   ArtsBB330

 

 

Thanks

Prachi

1 Reply

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Microsoft Employee

    Hi Prachi,

     

    The visuals seem simple. But we can't add or remove columns by slicers for now. Please vote up this idea or create a new one.

     

    Best Regards,

    Dale