Bookmark on slicer selection

[shaileng]

Hi there,

Need some urgent help using bookmark with Slicer choice.

Basically I have 2 grids (Grid1 and Grid2) and 1 slicer (Slicer1)

If on Slicer1 "All" option is selected then  I have to show Grid1 (and hide Grid2) and if any other are item is selected on the slicer1 then I have to show Grid2 (only and hide Grid1).

Earlier when I used bookmark I could make use ot images and thus link bookmarks however in above case running out of ideas. Please help

[v-haibl-msft · Accepted solution]

Agree with @parry2k, we can only use measure as a workaround, but column header will not be hidden.

Attached PBIX file is a simple sample. When we select 1 in the slicer, Table1 values will be shown. If we select 2 in the slicer, Table2 values will be shown.

Best Regards,
Herbert

[Anonymous]

@v-haibl-msft

Could you please help me to achive this. I guess your answer is what i need into my data. Please see the screenshot: i want to see only on column data at the time. Is this possible in slicer like you have used in your soltuion. Any help is appriciated. 

PS: I already tried bookmark but that having too many limitations.

Thank you, Kulchandra

[parry2k]

Unfortunately you cannot  select bookmark on slicer selection, currently it only works with image which you already mentioned in  your post.

Only work around I can think of is to create measure which you use in grid and those measure return blank values based on slicer selection, it will show blank grid but will still have headers.