Forum Discussion

khitish's avatar
khitish
Frequent Visitor
8 years ago

How to create conditional graphs in power BI

My requirement is to generate multiple graphs dynamically. For example, every time I filter a data 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.
Is this possible in power BI? Please suggest some ideas.
Need Help

9 Replies

  • bullius's avatar
    bullius
    Icon for Helper V rankHelper V
    8 years ago

    Just to clarify, you want there to be no graph before the slicer value is selected, then a whole graph appears after it is selected?

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Hi khitish,

     

    It may suitable for your requirement if you drag category/legend column as source of slicer.

     

    Regards,

    Xiaoxin Sheng

    • khitish's avatar
      khitish
      Frequent Visitor
      8 years ago

      Anonymous

       

      Thanks for your reply. My requirement is to generate a new pie chart or a bar graph, with the selection of the slicer.

      In your example, you have created a graph and then with your selection, your graph bars are getting added.

       

      I hope you understand my requirement now. I need a template where with each item selected in a slicer, a new graph will get generated.

      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

        Hi khitish,

         

        >>My requirement is to generate a new pie chart or a bar graph, with the selection of the slicer.

        Nope, current power bi not support auto generate new visuals based on slicer, it only support to operate filters on existed visuals by relationship.

         

        Regards,

        Xiaoxin Sheng