Forum Discussion
Solved
SLICERS -> blank value
I have a question about using slicers in my report. I make slicer which show the two years, I have just two values in my year table. But I also see blank value , is it possible to hide this one ? ...
adamgor A work around I use quite often is to start with a visual that allows you to filter the value, select/exclude the blank, then change the visual to a slicer and the blank should be gone.
I was experiencing this same issue with a very simple table (Hour). The data source did not have any null values, nor did the table that had a relationship with the Hour table, but the Blank() would still show in the slicer.
The fix to this issue for my situation was to check the "Assume Referential Integrity" box from within the relationship between the two tables. This will make the relationship an "inner join" eliminating the Blank().
MAAbdullah_47Helper V
Referential Integrity is not working in Power bi.