Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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??
if i filter only 2011 and i add slicer for customer name i wish to see in the slicer only lulu
customers | sales | year |
lulu | 400 | 2011 |
bubu | 200 | 2013 |
gogal | 300 | 2014 |
lulu | 400 | 2014 |
bubu | 200 | 2013 |
gogal | 300 | 2014 |
"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.
Regards,
Charlie Liao
User | Count |
---|---|
139 | |
113 | |
103 | |
73 | |
63 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |