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.

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
  • khitish's avatar
    khitish
    Frequent Visitor
    8 years ago

    Anonymous

    Thanks so much for your suggestion. I am in the process of trying your method. In the meantime, I am posting my exact requirement, if you can suggest me some better ideas.

     

    My requirement is to generate multiple graphs dynamically. For example, every time I filter an item in a slicer, for each item, a separate bar graph/pie chart should get generated.
    So once a user selects 2 values in a slicer. There will be 2 graphs plotted on the dashboard. Again, if the user selects 3 additional values in the slicer, there should be 3 additional graphs generated. All total 5 graphs should get displayed on the dashboard.

  • seaotter's avatar
    seaotter
    Frequent Visitor
    8 years ago

    AnonymousCould you share your file wi the community? Thank you very much!