How to represent dynamic filters

[gsrk1982]

Hi All,

Find the attached excel I am having Employee Data.For an Employee there is several attributes Department,Location,Grade etc.I am developed Report and placed report filters Department,Designation in Multi Select drop down list.

But  requirement came like below Instead of Placing every attribute as Slicer like below Only one Slicer will take all by dynamic.If I choose Department "X" axis is Department Name and count in "Y" axis.If I go like this I have to change the Data model.I am now using  "Direct Query" mode.But  for Slicer dynamic I have to Store values  like Attribute and Value in row based and storage will grow.If any other Way to achieve like this.

StaffidEmployee NameDepartmentGradeDesignationLocationDate of JoiningDate of LeavingGender

1000	Siva	Testing	Grade1	WORKER	Chennai	01-Jun-2001	14-Dec-2017	Male
1001	Ram	Development	Grade1	WORKER	Chennai	01-Sep-2001		Male
1002	Krishnan	Design	GRade2	WORKER	Chennai	10-Jun-2002	07-Sep-2018	Male

Filter By

Department

Designation

Grade

Location

Age

City

Experience

[v-danhe-msft]

Hi @gsrk1982 ,

Could you please tell me if your problem has been solved? If it is, could you please mark the helpful replies as Answered to close this topic?

Regards,

Daniel He

[v-danhe-msft]

Hi @gsrk1982 ,

Based on my test, you could use the Transpose function in query editor:

Regards,

Daniel He