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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
CheenuSing
Community Champion
Community Champion

Slicer to display values based on certain filtering of other columns

I have a table that contains Year and StageId. 

 

I want to have slicer that will show values of Year only for StageId > 0. How to acheive this.

 

 

 

Did I answer your question? Mark my post as a solution and also give KUDOS !

Proud to be a Datanaut!
1 ACCEPTED SOLUTION
itayrom
Resolver II
Resolver II

It's probably not an official solution(given the fact that there seems to be none...), but I found a workaround for that issue:

1. Click on your slicer.

2. Convert it to a Table visual(probably works with other visuals as well) by clicking on the "Table" button in the Visualizations pane.

3. Apply your visual-level filter on the table visual.

4. Convert it back to a Slicer visual.

5. The filter is now applied on the visual(Though it doesn't show on the visual-level filter bucket).

 

It seems to work in both Power BI Desktop and Service.

View solution in original post

6 REPLIES 6
itayrom
Resolver II
Resolver II

It's probably not an official solution(given the fact that there seems to be none...), but I found a workaround for that issue:

1. Click on your slicer.

2. Convert it to a Table visual(probably works with other visuals as well) by clicking on the "Table" button in the Visualizations pane.

3. Apply your visual-level filter on the table visual.

4. Convert it back to a Slicer visual.

5. The filter is now applied on the visual(Though it doesn't show on the visual-level filter bucket).

 

It seems to work in both Power BI Desktop and Service.

@itayrom@CheenuSing@Greg_Deckler

Unfortunately it does not work anymore.

 

=[

Sincerely,
Thales Ferraz

Yeah, instead of providing an official solution, they just disabled the workaround a few updates ago 😕

This would be perfect...It doesnt work now. C'mon powerbi team. Its simple and useful feature!!!

Greg_Deckler
Super User
Super User

Not sure if you are in the Service or Desktop, but essentially, drag StagId to your visual filter area and set to be greater than 0.



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...

Hi Smoupre

 

I am using both. Unfortunately in neither the visual filter does not seem to get enabled for a Slicer object. Only the Page and Report level filters get enabled.

 

I am not sure if it is a limitation.

 

CheenuSing

Did I answer your question? Mark my post as a solution and also give KUDOS !

Proud to be a Datanaut!

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

FebPBI_Carousel

Power BI Monthly Update - February 2025

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

Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Feb2025 NL Carousel

Fabric Community Update - February 2025

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