Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code FABINSIDER for a $400 discount.
Register nowThe 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.
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.
Solved! Go to Solution.
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.
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.
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!!!
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.
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
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Check out the February 2025 Power BI update to learn about new features.
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
10 | |
3 | |
3 | |
2 | |
2 |
User | Count |
---|---|
19 | |
6 | |
5 | |
3 | |
3 |