Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
vinodDrinkPak
Helper II
Helper II

Duplicate date values in my dropdown list

Hi,

 

with the help of chat GPT i have create a calculated coloumn 

End of Week =
    IF(ISBLANK([Shipment date]), BLANK(),
        [Shipment date] + 7 - WEEKDAY([Shipment date])
    )
But when i use this coloumn as Dropdown in my dashboard, it repeats the values, ideally dropdown should be distinct values. i am not sure why my End of the week is repeating in slicer?
any help or suggestion would be great!
 
vinodDrinkPak_0-1693752635258.png

 

4 REPLIES 4
abpgupta
Continued Contributor
Continued Contributor

You probably need to create a separate Date table and join with fact table. That would be more efficient and work all time rather than using DAX functions such as distinct to handle above slicer duplicate issue.

 

Please search ChatGPT on how to create date table for your model.

   

foodd
Super User
Super User

Hello @vinodDrinkPak and thank you for starting a conversation in the Power Query Forum.   It is unclear from your description what the problem with your data model is.   Would you please add your work-in-progress Power BI Desktop file, as well as any source files in Excel format.    To add the file, copy your file to Google Drive, One Drive, or Dropbox, add the anonymous sharing link to the original post, and add a reply to the thread that the post has been updated, and these have been added.  Please also with an image and description, of what the desired results should be.

thanks, i manage to resolve the issue, End of week, i have calculated in M Query and then added that to slicer, it sorted out the issue

Great that you self-discovered a working solution!   Please mark this reply as a solution and provide Kudos so that others may find the solution easier.

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.