(blank) tile showing up in slicer with other tiles

[_Janwi31]

I have a column containing sales person names which I want to use as slicer. There are total 3 names in it. But when I am putting it in the slicer chart, another value is showing - (blank).

The values that should show for Pawan are now under (Blank) and for Pawan and General the values are null (showing blank).

Please help. It's really urgent.

[Uzi2019]

Hi @_Janwi31 
Can you share the data modelling details?? Or a sample data in excel ??

I think you data is not mapped correctly against sales person.


If my post helps give kudos and accept it as  a solution!

[_Janwi31]

Hi @Uzi2019 ,

I am sharing a sample data in excel. Please go through it and let me know if there is any error.

[Uzi2019]

Hi @_Janwi31 
I dont find any attachment. please share the data.

[_Janwi31]

Hi @Uzi2019 ,

Thank you so much for your willingness to help me with my Power BI issue. Although the problem got resolved now, I truly appreciate your time and willingness to assist. Your dedication to helping the community is commendable!

[Uzi2019]

Hi @_Janwi31 
Ohh great. You've resolved the issue.
Thank you!

[Ritaf1983]

Hi @_Janwi31 
Based on the verbal explanation and attached images, it is very difficult to understand what you are trying to do and where the problem is.

Please attach a link to a sample PBIX file and a picture of the desired result.