cancel
Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

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
PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors