Forum Discussion
JSiebrecht
Resolver I
Resolver ISlicer 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 (...
- 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.
JSiebrechtResolver I
Resolver IFOOOOUUUUUNNNNDDD 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.