Forum Discussion
Slicer inconsistent, all filled, or all empty
Hi, I have a slicer with only two values. There are no other values available, nor any blancs.
If I select both values I should select everything, and I get a result of a checksum that is say 500.
Now the strange part. If I leave the slicer all empty, normally that is the same thing, select everying. But now I get a value of 700!
Something is filtering in the relations in one table, when it should not. Can any give my a hint what is going on behind the scenes? If I delete the slices all together I also get 700. So I get a feeling there is an optimization down deep in Power BI that will omit a check if nothing is selected, but is triggered then everying is selected. I just cannot find what is wrong.
Any ideas?
3 Replies
- jdbuchanan71
Super User
Anonymous
It will be very difficult to help with your question without being able to see your data model. Please take a look at this post to give you an idea of the information we need to help you.
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/td-p/1447523
