How to create conditional graphs in power BI

[khitish]

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.

[bullius]

It is not using a slicer, but the new selection/bookmarks pane might provide the functionality you need. As mentioned, there is no way to add a visual out of nothing by clicking on a slicer, but there are ways of hiding visuals that already exist.

Check this out for help: https://docs.microsoft.com/en-us/power-bi/desktop-bookmarks

[v-shex-msft]

Hi @khitish,

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

Regards,

Xiaoxin Sheng

[khitish]

@v-shex-msft

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.

[v-shex-msft]

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

[bullius]

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?

[khitish]

@bullius

Yes, you are correct.

In the slicer
No option selected: no graphs
2 options selected: 2 graphs will be generated.
Again one option deselected: one graph should disappear.

Hope I clarified your doubt.

Do you have any solution for me?

[khitish]

Yes, you are correct.

In the slicer
No option selected: no graphs
2 options selected: 2 graphs will be generated.
Again one option deselected: one graph should disappear.

Hope I clarified your doubt.

[pxg08680]

@khitish

Not exactly but this can help you a bit.

http://community.powerbi.com/t5/Desktop/Change-visual-types-with-slicer/m-p/301203#M133076

[khitish]

Still searing for the solution. Please suggest.