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

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Reply
mehaboob557
Resolver III
Resolver III

Swap visuals based on bulk filter button

Hello ALL,

 

I am learning PowerBI and i am in need of help from experts like you.

 

I need to keep button like filters.  Suppose, button1 consisits of set of versions(i.e versions 0.1, 0.2 , 0.3 ,.. 0.9) buttun2 consistes of another set of versions(i.e versions 1.1, 1.2, 1.3 ,... 1.9).

 

I want to use these two buttons like filters. If i select button1, visulas will be showing only those values which have versions 0.1 to 0.9 . If i click on button2 in the same visual, it should show the values having versions 1.1 to 1.9

 

Is this possible? if possible, how can i achieve this.

 

Please suggest me your ideas

2 REPLIES 2
v-sihou-msft
Microsoft Employee
Microsoft Employee

@mehaboob557

 

If those values "0.1~0.9" and "1.1~1.9" are filtering same column, it's not possible to split them into two slicers. 

 

In this scenario, you can create a bucket column like:

 

Bucket =IF(Table[Column]<1,"0.x","1.x")

Then you can put this bucket column into a slicer. When you select a "bucket", the corresponding values will be cascading filtered in another slicer.

 

Regards,

Will implement and if it works i will accept your solution.

 

Thank you so much @v-sihou-msft

 

Helpful resources

Announcements
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

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

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors