cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
gsrk1982 Frequent Visitor
Frequent Visitor

How to represent dynamic filters

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

1000SivaTestingGrade1WORKERChennai01-Jun-200114-Dec-2017Male
1001RamDevelopmentGrade1WORKERChennai01-Sep-2001 Male
1002KrishnanDesignGRade2WORKERChennai10-Jun-200207-Sep-2018Male



Filter By
Department
Designation
Grade
Location
Age
City
Experience
2 REPLIES 2
Community Support Team
Community Support Team

Re: How to represent dynamic filters

Hi @gsrk1982 ,

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

1.PNG

 

Regards,

Daniel He

Community Support Team _ Daniel He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Community Support Team
Community Support Team

Re: How to represent dynamic filters

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

Community Support Team _ Daniel He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.