CODEWITHSUNDEEP
powerbidaxpowerbi-embedded
Serdia
Serdia

Reputation: 4426

How to limit the number of available values in a slicer based on fact table?

I have Overall_Results table that has ProducerGUID column. It contains approximately 146 unique ProducerGUID.

Table Producer (contains 1,300 unique ProducerGUID) joined with Overall_Results via ProducerGUID.

enter image description here

When using a slicer 'ProducerName' it displays all 1,300 different producers.

Is any way to limit the number of unique producers in a slicer and only display those that table 'Overall_results' has? Which is approx 146 of them instead of 1,300?

enter image description here

Upvotes: 0

Views: 1116

Answers (1)

Alexis Olson
Alexis Olson

Reputation: 40224

The first thing I would try is to make the relationship between Overall_Results and ProducerGUID cross-filter in both directions.

If that doesn't work, you could also try doing an inner join in the Query Editor so that only the matching ID values show up.

Upvotes: 1

Related Questions