unique values filter in power bi dashboard

[Aartibhilare]

i have updated the eventname in database now

but filter dropdown not refelcting with new values as well as i dont want chrismas multiple time

[SamInogic · Accepted solution]

Hi,

As per my understanding, you are facing an issue with filtering out distinct values in the slicer, but the slicer already returns distinct values by default, when you're using a slicer for a column like EventName that contains repeated values (e.g., Christmas, Halloween), but you only want to show distinct values in the dropdown, you can achieve this easily by ensuring that the slicer only shows unique values.

Here’s how you can ensure the slicer shows distinct values:

1. Use a Slicer:
• In Power BI, add a slicer to your report.
• Drag the EventName field into the slicer.
2. Remove Duplicates from the Slicer:
• By default, Power BI slicers will display each distinct value once, even if there are duplicates in the data.
• If you see repeated values, ensure you're working with the correct field and not a calculated field or measure that might not be distinct.

If you need to make sure the data in the slicer reflects only distinct values, use the following approach:

3. Create a Distinct List of Values: You can create a new table that contains distinct values of EventName.

• Go to Modeling → New Table and use the DAX formula:

DAX

DistinctEvents = DISTINCT(YourTable[EventName])

This formula creates a new table DistinctEvents that contains only unique EventName values from your original table.

• Use the New Table in the Slicer:
• Drag the EventName from the new DistinctEvents table into the slicer.
• This will show only distinct event names in the slicer.
• Format the Slicer as a Dropdown:
• You can then format the slicer as a dropdown by clicking on the slicer and selecting the dropdown icon in the visualizations pane.

Now, the slicer will show only distinct values, and the user can select from a dropdown without duplicates.

Thanks!

[AnkitaaMishra]

Hi @Aartibhilare , 
For distinct records, you can create a calculated table with distinct records and then create a relationship between your original table and the calculated table as one to many relationship. 
Now use the column from calculated table in the slicer, this will give you only unique records in your slicer.

for the refresh issue, you can manually check refreshing it in the power query and see if the values are reflecting or not.

Please let me know if I misunderstood anything or share more details for your query.

If you’re satisfied with the answer, don’t forget to mark it as the solution to help others find it faster.

A thumbs-up is always appreciated!

Thanks,

Ankita