Dynamic column based on slicer selection

[prachipriyam5]

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

[v-jiascu-msft]

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