Forum Discussion
Helper IHide visual but keep selection from hidden visual
dlogan in my testing, it works the same - when you hide a visual, it no longer filters the data on the report UNLESS that visual is a slicer.
I would suggest looking into using 'drillthough' functionality and different pages, rather than one page to rule them all.
https://excelwithallison.blogspot.com/2020/12/seventh-day-of-christmas-conditional.html
Community Championim not sure is this would help ,
but you can do something like this :
in this image i have 2 visuals.
if no selection is done on visual 1 , the second visual will not show any data,
but , as soon as you select any row from the first visual , visual 2 start showing the data related to the selection
if this is something you want, you can achieve it by creating a measure that will check if you have a filter on the columns of the first visual .
then this measure you will put it in the filter pane - on visual level for the other visuals,
measure = 1
let me know if this works for you
Helper IThis is not working. As soon as the first visual is changed to hidden, the second visual resets to show all records. Test it on the example you showed.
This is when the first visual is not hidden and has a selection
This is after the first visual is hidden. The second visual changes and shows all records.
- Daniel29195
im assuming that your bookmarks are saving the data ? if so , then the filter that you have added in the filter pane for the visual will reset because the bookmark have been created before adding this measure in the filter pane
so you need to recreate the bookmarks taking into consideration the measure in the filter pane, or if you dont need to save the state of the data, just ignore saving the data in the bookmarks .
unselect data and update the the bookmark .
let me know if the problem persist.
- dlogan
I just can't get it to do what you say it should do. Are you able to take a look? Let me know if this link works or not. Thank you for continuing to help.
- Daniel29195
yes sure, i will check it and get back to you as soon as possible. dlogan