Forum Discussion

JSiebrecht's avatar
JSiebrecht
Icon for Resolver I rankResolver I
5 years ago
Solved

Slicer shows duplicates once published

I obsever an annoying phenomenon I can't resolve: I have a slicer for data with duplicate entries in the underlying table column. In Power BI Desktop it shows each value only once in the slicer (...
Need Help
  • JSiebrecht's avatar
    JSiebrecht
    5 years ago
    FOOOOUUUUUNNNNDDD IT!
    After three days of troubleshooting and deleting one measure at a time, publishing and checking it the problem persists, I finally found the problem!
    Turns out, the calculated column I used in my slicer ("Date Selection") was unnoticed specified to be sorted by an other calculated column ("Quarterhour").
    Why? Don't know.
    Why this caused the slicer to show the items multiple times? Don't know either.
    But I now specified "Date Selection" shall be sorted by itself, published it and VOILA! Works again.
Volha's avatar
Volha
Regular Visitor
5 years ago

Hi! Have the same problem, but in my case there is important to save sort column by another column. Any ideas?