Forum Discussion
Show /Hide two overlapped visuals based on slicer selection
Hello Community ,
I have two visuals on top of each other (overlapped) : one is line chart (visual displayed by default) and the other is clustred column chart
I would like to display the clustred column chart visual when I select one of the first three slicer values
and the visual line chart for the fourth slicer
so it displays one and disappears the other
how I can do it with the dax language
Thanks a lot
Anonymous
Please check this video https://www.youtube.com/watch?v=_Afcj8mT5_Q
Thanks,
Ritesh
Mark my post as a solution if it helped you| Munde and Kudis (Ladies and Gentlemen) I like your Kudos!! !!
My YT Channel Dancing With Data !! Connect on Linkedin !! PL 300 Certification Seriesnot using a slicer, you will a woraround using buttons:
1) create two visual bottons lets say for example "on" and "off"
2) create the 2 visuals and overlap them in the position they going
3) open the selection tab, bookmark tap
them create 2 bookmarks, hide the 1 visual and 1 botton, create a bookmark with it int ehe given condiitons and effects you want, them create a second bookmark with the contrary hide/show visuals botton icon
them assing a bookmark to each botton and when clicked there you go the visual changes,
Note: this workaround if used for tons of visual will affect the report page performance.
2 Replies
- ribisht17
Super User
Anonymous
Please check this video https://www.youtube.com/watch?v=_Afcj8mT5_Q
Thanks,
Ritesh
Mark my post as a solution if it helped you| Munde and Kudis (Ladies and Gentlemen) I like your Kudos!! !!
My YT Channel Dancing With Data !! Connect on Linkedin !! PL 300 Certification Series - StefanoGrimaldi
Resident Rockstar
not using a slicer, you will a woraround using buttons:
1) create two visual bottons lets say for example "on" and "off"
2) create the 2 visuals and overlap them in the position they going
3) open the selection tab, bookmark tap
them create 2 bookmarks, hide the 1 visual and 1 botton, create a bookmark with it int ehe given condiitons and effects you want, them create a second bookmark with the contrary hide/show visuals botton icon
them assing a bookmark to each botton and when clicked there you go the visual changes,
Note: this workaround if used for tons of visual will affect the report page performance.