Forum Discussion

AmiraBedh's avatar
AmiraBedh
Icon for Super User rankSuper User
4 years ago
Solved

Null values appearing while the dimension doesn't include any

I have a dimension EmployeeFunction who has the different functions of employees linked to a fact table EmployeeHRProgress linked to the dimension EmployeeFunction with a 1 to many relationship. Wh...
General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
v-yalanwu-msft's avatar
v-yalanwu-msft
Icon for Community Support rankCommunity Support
4 years ago

Hi, AmiraBedh ;

I think one side of your table relationship does not have matching value that is why blank is appearing in your slicer. 

One method:

Filter on slicer visual and unselected blank().

 

Or Why would there be a blank value in the slicer? The reason it appears is because of a data integrity issue. so you could fix data.

blank-value-in-the-power-bi-slicer 

 This can be done in both Fact and Dimension tables with a simple trick to remove the (Blank) value in slicer and filter .

Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.