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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
vally57
Frequent Visitor

Power BI Slicer values change

In power BI, I have a table named Sample which contains status, File Name, Email columns. the status column contains 'Excel' and 'PDF' duplicate Values . I want to use status column as a slicer, here i want to see the values in the slicer 'Excel', 'PDF' and 'Combined' instead of Excel, PDF and 'Select All'. So if I select Excel from the slicer then it should display Excel related records, if we select PDF then it should show PDF related records, if I select Combined then it should show both Excel and PDF related records in the tabular visual. The tabular visual contains File Name, Email columns .how can we do this

Thanks!

2 REPLIES 2
iceparrot
Advocate II
Advocate II

Hey @vally57 ,
if I get you right you want to achieve something like this:

iceparrot_0-1695391830927.png

Which would look like this if you select PDF:

iceparrot_1-1695391857002.png


If this is what you're looking for, you just need to place the table visual on your report page and add the slicer visual to the report page as well. For the slicer visual then select the STATUS column of your table which contains the information about EXCEL or PDF. 

Please let me knwo if this helps you.

hey @iceparrot 

In the STATUS slicer now we have 'Select all', 'Excel' and 'PDF' values. But I want to show 'Combined', 'Excel' and 'PDF' values. Here instead of Select all I want Combined, if I select Combined from the slicer, the table should display both Excel and PDF related records.

Helpful resources

Announcements
Fabcon_Europe_Social_Bogo

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.