Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Anonymous
Not applicable

How to group various fields to create custom filter

Hi All,

Is there a way to group various fields to create a custom filter? It would basically be like a folder creating a group of fields. For example, I have a list of custom Filters here like 'Load', 'Stop', 'Origin', etc. which in turn contain various other fields within them for filtering like 'Load' contains 'Loadnum', 'Load Status', 'Mode Description', etc. Similarly follow other screenshot for 'Stop'. 

sakshidixit_2-1615917430797.png

Thanks in advance.

 

 

5 REPLIES 5
User5231
Helper II
Helper II

Can't you just make a table of all the filters with a second column that has the grouping defined? Then you can create relationships and select by group (Load, etc).

 

Maybe I am missing the desired intent.

pranit828
Community Champion
Community Champion

Hi @Anonymous 
How about you use the slicer and put multiple columns in it as below screenshot.

pranit828_0-1615917946104.png

It will appear as multidrop down.





PBI_SuperUser_Rank@1x.png


Hope it resolves your issue? 
Did I answer your question? Mark my post as a solution!

Appreciate your Kudos, Press the thumbs up button!!
Linkedin Profile
Anonymous
Not applicable

Hi @pranit828

Thanks for reverting, but it will be a visualization. I require to have this within the "Filters" panel. Is grouping of fields possible to achieve under Filters?

Hi @Anonymous ,

 

As far as I know, there is no such feature for the time being.

It is suggested that submit your idea to help improve power bi.

https://ideas.powerbi.com/ 

 

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

Anonymous
Not applicable

Hi @V-lianl-msft, yes have already done that. Below is the link. Can promote it, if find it useful. 

Thanks in advance.

https://community.powerbi.com/t5/Custom-Visuals-Ideas/Grouping-of-Filters-in-a-Folder/idi-p/1730930

 

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.