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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
diklaida
New Member

relative values in slicer

tables for sales per customer

and slicer for customer name

I want to see in the slicer only the customer which have value in the table (sales value) and not all the possiable customer ever opened

 

is there a way??

 

3 REPLIES 3
Anonymous
Not applicable

@diklaida

 

Can you make an example of how your data stored?

if i filter only 2011 and i add slicer for customer name i wish to see in the slicer only lulu

 

customerssalesyear
lulu4002011
bubu2002013
gogal3002014
lulu4002014
bubu2002013
gogal3002014

@diklaida,

 

"if i filter only 2011 and i add slicer for customer name i wish to see in the slicer only lulu"

Did you filter your data by using page filter?

If that is the case, slicer items will changes dynamically based on the filter. The thing you need to do is that use customers column in your sales table in slicer.
Capture.PNGCapture1.PNG

 

Regards,

Charlie Liao

 

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

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

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors