Forum Discussion

KevinsKanban's avatar
KevinsKanban
Frequent Visitor
2 years ago
Solved

When Slicer uses a date range, the format is inconsistent after publishing to the service.

While editing on desktop [2020/1/1] [2022/8/31] After publishing to the service [1/1/2020] [31/8/2022] desktop version:    
  • SaiTejaTalasila's avatar
    2 years ago

    Hi KevinsKanban ,

     

    You can try this -

    • Open your PBIX file > Go to Transform Editor (Power Query Editor)
    • Select the Date Column > Right Click on Column Name> Change Type > Using Locale

     

    • Once you click on Using Locale, a window pops-up with the below options

     

    • Change Data Type to Date or DateTime and Locale to your desired locale type
    • And click on OK and apply the transformations and publish to service

    I hope it will be helpful.

     

    Thanks,

    Sai Teja