Dynamic graph changes as filter changes

[ktt777]

Hi all,

is it possible to create a graph that change X-axis as the filer change. 

For example, if i am select fruit, then the graph show number of Orange and Apple. 

If i select Meat, then it shows Beef and Pork

thanks, here is the link the PBI file :Dynamic Graph.pbix

[v-zhengdxu-msft · Accepted solution]

Hi @ktt777 

Please try this:

First of all, I create a set of sample because the link you provided can't be opened:

Then add a column chart and a slicer

Select the bookmark in the View pane:

And add a bookmark named 'Group' :

Click this icon and add a bookmark as 'Type':

Next, select bookmark navigator in the Insert pane:

So you can change the x-axis by the two bookmark and select by slicer, the result is as follow:

Best Regards

Zhengdong Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[ktt777]

thank you, but i want the graph still show at group type when the fillter does not select for any type. 

the graph and change to product when one of the group type is selected

[Bmejia]

You can do this base on how your data is structure.
If all the data like the Group Type and Product is on the same table then you can build your graph base on the Product (Apple, Orange,et..) Then just have your filter build on the group type.

If you have your data in different tables they you need to create a relationship between and do the same as above create the graph base on the product and your filter base on the group type.

If you do not have the product type any where then you would need to create a table that you would need to maintain as you add new products and add the group they belong to. Then create a relationship with the main table and create the graph again base on the products filter on group type.