Hidden slicer affecting visuals

Question

Hello everyone,I'm new to Power BI and I'm stuck with one problem. I'll try to make a simple example here. I'm using the september 2019 PBI for RS version.I have two types of Date: one related to the year the product was received (button "Data") and another related to the year the product was made (button "FY"). For example, I received a product in 2019 but it was made in 2018.For this situation, I created two buttons to switch between "Data" and "FY" and two chiclet slicers, one for each button.I want to check how many products were received in 2017. So, I pick the button "Data" and 2017. The result is shown as below. However, this result is still being affected by the hidden chiclet slicer from "FY". Is there anyway I can overcome this situation? That is, the result being affected only by one of the filters.I believe the hidden filter shouldn't be affecting any of the results in the page. I'm using bookmarks for this, that affect the 2 mentioned buttons and the two chiclet slicers. I also confirmed that there are no other hidden slicers.&nbsp;Thank you very much in advanced for any help or tips.

mfelix · Answer

Hi&nbsp;Carlokes&nbsp;
&nbsp;
When you are hiding visualizations you are only doing it on a visual level not on an interaction level. Using the bookmarks you have one option that is the link to data or not.
&nbsp;
If you have that link to data the bookmark will save the filters you have when you create the bookmark if you have it oof if you have any filter/slicers/selections the bookmark will adjust to those new values.
&nbsp;
In this specific case believe the best option is using calculation groups instead of bookmarks because using a slicer you are abble to change between measures.
&nbsp;
https://www.sqlbi.com/blog/marco/2020/07/15/creating-calculation-groups-in-power-bi-desktop/#:~:text=Calculation%20groups%20can%20apply%20specific,variations%20of%20the%20base%20measures.
&nbsp;

Forum Discussion

Hidden slicer affecting visuals

1 Reply

Related content

Hidden Features

Make visual affect slicer

Hidden visuals setting data

Hide visual but keep selection from hidden visual

Filter not affecting Visual