Forum Discussion

jdballard's avatar
jdballard
New Member
8 years ago

Table shows blank with slicer value selected

I have a slicer based on a field named "Marketer". I select a value in that field such as "John Marketer".

 

Below, I have a table that has the same field in it that the slicer is based on. In that table I'm seeing rows that have blank values in the Marketer column. I would expect them to not show up in the table as I've selected the value "John Marketer" in the slicer. I can add an advanced filter to my table of "Marketer is not blank", but I'd think I shouldn't have to as I've already seleted a value in the slicer. Is this normal behavior?

2 Replies

  • parry2k's avatar
    parry2k
    Icon for Super User rankSuper User
    8 years ago

    This doesn't seems to be normal, sure something else is going on . What else in that table? Do you other tables and have relationship?

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    8 years ago

    Hi jdballard,

     

    Could you please provide more information about the fields added to table visual? Please add only [Marketer] column into visual, test whether it shows blank rows when you select "John Marketer" in slicer. If possible, could you share the .pbix file?

     

    Regards,

    Yuliana Gu