Why Power BI Slicers Sometimes Show Values That Do Not Exist
The problem of blank values being shown in a Power BI slicer is fairly well known, but did you know that in some circumstances slicers can show other values that you would not expect to see? While there’s a good reason for this it can nevertheless be mildly confusing for developers and end users alike when it happens.
Let’s take a look at one way this can happen. Here’s an M query that returns a table with up to five random numbers in: