Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

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
Resident Rockstar
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

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
Resident Rockstar
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

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
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.