Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
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
Solved! Go to Solution.
@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
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.
Proud to be a 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
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.
Proud to be a 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
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
56 | |
55 | |
54 | |
37 | |
29 |
User | Count |
---|---|
77 | |
62 | |
45 | |
40 | |
40 |