cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

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

2 ACCEPTED SOLUTIONS
ribisht17
Super User
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

View solution in original post

StefanoGrimaldi
Super User
Super User

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

StefanoGrimaldi_0-1664130941318.png

 

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. 





Did I answer your question? Mark my post as a solution! / Did it help? Give some Kudos!

Proud to be a Super User!




View solution in original post

2 REPLIES 2
StefanoGrimaldi
Super User
Super User

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

StefanoGrimaldi_0-1664130941318.png

 

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. 





Did I answer your question? Mark my post as a solution! / Did it help? Give some Kudos!

Proud to be a Super User!




ribisht17
Super User
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

Helpful resources

Announcements
PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Top Solution Authors