cancel
Showing results for 
Search instead for 
Did you mean: 
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
Carousel_PBI_Wave1

2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

BizApps LATAM 2023

Business Application LATAM Summit 2023

Join the biggest FREE Business Applications Event in LATAM this February.

Power Platform Bootcamp

Global Power Platform Bootcamp

In this bootcamp we will deep-dive into Microsoft’s Power Platform stack with hands-on sessions and labs, delivered to you by experts and community leaders.