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

Score big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount

Reply
abottino
New Member

how to filter multiple vendors number?

goodmorning gents, talking about the P&SC OTD dashboard, how can I filter a multiple vendors number selection, for example more then 30 vendors in the dashboard? the onl way I found is to filter manually by vendors number that it takes lot of time and trial so no really feasable.

thank you for your suggestions

 

regards

 

Alessandro

1 REPLY 1
BA_Pete
Super User
Super User

Hi @abottino ,

 

It sounds like you could add 'vendor groups' to your vendor dimension table to speed up bulk selection.

In your vendors dimension, you would have, say, [vendorID], [vendorName], [vendorAddress] etc.

You could add a new custom column that groups the vendors by region, or product type, or payment terms etc.

You then use the new [vendorGroup] column in a slicer to narrow down the potential vendors very quickly.

 

Pete



Now accepting Kudos! If my post helped you, why not give it a thumbs-up?

Proud to be a Datanaut!




Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

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

Top Solution Authors