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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

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
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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