Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
MbProg
Helper II
Helper II

Filter a slicer

‎08-31-2016 03:13 AM

I have a table of data which I want to filter the other diagrams with it. So I am using a slicer. But I don't want to show all data in the slicer but just a filtered version of it. How can I do this?

Before the June update there was a hack where you could first create a table diagram with the data, then filter it and convert it to a slicer to have a visual filter. But now it is not working!!

Does anyone know a workaround?

Labels:
Message 1 of 4
3,151 Views
0
1 ACCEPTED SOLUTION
MattAllington
Community Champion
Community Champion

‎08-31-2016 04:15 AM

How about apply a filter on the same column in the filters pane on the right of the canvas. Just filter out the items you don't want to see in the slicer, and you will just see the others. 


* Matt is an 8 times Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.
I will not give you bad advice, even if you unknowingly ask for it.

View solution in original post

Message 2 of 4
4,214 Views
3 REPLIES 3
MattAllington
Community Champion
Community Champion

‎08-31-2016 04:15 AM

How about apply a filter on the same column in the filters pane on the right of the canvas. Just filter out the items you don't want to see in the slicer, and you will just see the others. 


* Matt is an 8 times Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.
I will not give you bad advice, even if you unknowingly ask for it.
Message 2 of 4
4,215 Views
MbProg
Helper II
Helper II
In response to MattAllington

‎08-31-2016 05:09 AM

@MattAllington Good idea 🙂 Thanks .

Message 3 of 4
3,140 Views
0
v-haibl-msft
Microsoft Employee
Microsoft Employee
In response to MbProg

‎08-31-2016 11:29 PM

@MbProg

 

MattAllington’s idea should be a good solution and you can also vote this idea in following two links.

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/15091614-can-no-longer-filter-a-s...

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/12545673-visual-level-filtering-i...

 

Best Regards,

Herbert

Message 4 of 4
3,120 Views
0

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!

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.

View All