Forum Discussion
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 the botton to change visual appear again the blank value, we try to use the filter in all level (Object, page, all Pages) but the result is the same, some one have any idea?
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
8 Replies
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
Hi AngelMN ,
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. And, if you have any further query do let us know.
Regards,
Dinesh
Hello Dinesh, I tried your proposal and the board is fixed, your proposal is logical, but it didn't occur to me, thank you very much, greetings
Hi AngelMN,
if I got you correct, do you want to have the top slicer to be independent of the left one (radio button selection)?
As I assume both slicers are having the same context (date table) the behaviour you see is expected. Especially if you have "blank" values within the selected radio button date range.
What you can do is, "Edit interactions" between both of your slicers. This allows you to have a independent behaviour between those two. Check out the docs for more details: Change how visuals interact in a report - Power BI | Microsoft Learn
Best regards!
PS: If you find this post helpful consider leaving kudos or mark it as solution
thanks for your response, I read the post, but the iteraction isn´t with the other left slicer (Periodos), is with the down bottons (Responsable, Formatos), in the picture, I show that we have two botton, these change the rigth grid, and hide the other botton subsecuently, and vicerversa, in this change is when the level (nivel) slicer appear the blank (en blanco) option, and on the filter pane is available the blank (En blanco) option again, with the botton I can´t use edit interactions, thanks again
Ok got it. With the context of your other reply, my question is: Have you check what happens if you select the "blank" value option in the filter option? I assume there need to be data which has no corresponding value related to the attribute "Nivel". And thats why you get them. Maybe worse checking or sharing the model relationships between your tables.
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
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
-
