Forum Discussion

AngelMN's avatar
AngelMN
Regular Visitor
6 months ago
Solved

Black slicer apper when change Visual

Hello,   I hope that you undertand me, we have a Dash with a education level slicer, alte we have a change botton visual, in the filter page we uncheck blank value of this slicer, but when press th...
blank values
Power Bi Slicer
  • v-dineshya's avatar
    v-dineshya
    6 months ago

    Hi AngelMN ,

    Thank you for reaching out to the Microsoft Community Forum.

     

    Your slicer shows “(En blanco)” again whenever you press the button that switches the visual. This happens when the button is tied to a bookmark and that bookmark captures data state. When you click the button, the bookmark restores the slicer’s state, including bringing back “(En blanco)” even if you manually unchecked it in the Filter pane.

     

    Please follow below steps.

    1. Open the Bookmarks pane, View --> Bookmarks.
    2. Select the Bookmark used by the Button, Click the bookmark that your button is triggering.
    3. Uncheck "Data" and "All visuals", Click the three dots (…) next to the bookmark and select "Selected visuals".

    4. Now select only the visuals you want to show/hide and click update option in bookmarks.

     

    Please refer below snap.

     

    I hope this information helps. Please do let us know if you have any further queries.

     

    Regards,

    Dinesh

cengizhanarslan's avatar
cengizhanarslan
Super User
6 months ago

If your slicer is based on a column that has real blanks / nulls in the model, (Blank) will always exist. Filtering it out in one place won’t remove it from the model. Best practice is to handle it in Power Query / DAX:

  • Replace nulls with “Unknown” or remove them (if valid)

  • Or filter them in the dimension table

AngelMN's avatar
AngelMN
Regular Visitor
6 months ago

thanks for your response, I´ve review and don´t have null values on the dimention and facts tables, I´ve public other response with edit interactions and a little more the text with my explain that hope it´ll better, thans again