Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Change visual types with slicer

Hi All, I am relatively new with Power BI Desktop. I am working on a task in which you have a slicer that contains a list of different visual types, and based on the value selected, the visual type ...
  • tjd's avatar
    tjd
    8 years ago

    Don't think you can do that directly via a slicer.  However, it should be easy enough to put together using the bookmarks and view selection features.  You make your 3 or more visuals and overlay them and connect your "slicer" to bookmarked pages.  As each slicer button is selected, two (or more) visuals are hidden and the selected one is shown.  Good luck.

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Yes, the slicer should have different visual types like bar chart, pie chart, map, or table ... Something like this

https://ibb.co/kxpNYG

https://ibb.co/eXuT7b

So if I click on Map, it should take me to total sales by country in form of a map. Or if click on Pie Chart, it should display sales by country in form of a pie chart

tjd's avatar
tjd
Icon for Impactful Individual rankImpactful Individual
8 years ago

Don't think you can do that directly via a slicer.  However, it should be easy enough to put together using the bookmarks and view selection features.  You make your 3 or more visuals and overlay them and connect your "slicer" to bookmarked pages.  As each slicer button is selected, two (or more) visuals are hidden and the selected one is shown.  Good luck.

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    I got it figured out. Thank you so much for the help!

    • khitish's avatar
      khitish
      Frequent Visitor
      8 years ago
      Hi Nick,

      I have a similar problem. Not sure how to proceed. Can you please help me out.

      Thanks,
    • khitish's avatar
      khitish
      Frequent Visitor
      8 years ago

      Anonymous

      I have a similar problem. Not sure how to proceed. Can you please help me out.

      Thanks,

      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago
        khitishBasically I enabled Bookmark feature in Power BI desktop. You can look at October release of Power BI to figure it out. Then I created two bookmarks, first one showing map reports and hide tables, the second bookmark showing only tables and hide maps. Finally I created linking on a toggle-on button image in the first bookmark(which you can download the images anywhere) then link this to the second bookmark. On the second bookmark I created linking on a toggle off button which will take you to the first bookmark. The same concepts can also be applied when you have mutiple types of reports you want to dynamically select. Let me know if it helps