Forum Discussion
prachipriyam5
8 years agoRegular Visitor
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 Selection | Department | User Selection | Department,Student | ||
| Department | Marks | Department | Student | Marks | |
| Science | 100 | Science | AA1 | 50 | |
| Arts | 100 | Science | AA2 | 20 | |
| Science | AA3 | 30 | |||
| Arts | BB1 | 50 | |||
| Arts | BB2 | 20 | |||
| Arts | BB3 | 30 |
Thanks
Prachi
1 Reply
- v-jiascu-msftMicrosoft 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