Help! Can we use distinct filter?

[TheTeam35]

Hi all,

I created a Power BI Desktop Report and published it.

I use DirectQuery mode.

I want to add a "distinct" filter.

How can I add?

For example; the report has the same rows.

When I click the button or filter then I don't want to see the same rows.

Is it possible?

Thanks.

Erdem

[v-easonf-msft]

Hi， @TheTeam35 

What does your data look like? Can you share your sample pbix file?

As @amitchandak  said, duplicate values are unlikely to occur in a slicer.

Best Regards,
Community Support Team _ Eason

[amitchandak]

@TheTeam35 , All slicer, and filter show only distinct values only?  Is that not true in this case