Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
ktt777
Helper V
Helper V

Dynamic graph changes as filter changes

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

ktt777_0-1711029405448.png

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

1 ACCEPTED SOLUTION
v-zhengdxu-msft
Community Support
Community Support

Hi @ktt777 

 

Please try this:

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

vzhengdxumsft_0-1711072455953.png

Then add a column chart and a slicer

vzhengdxumsft_1-1711072500732.pngvzhengdxumsft_3-1711072530118.png

Select the bookmark in the View pane:

vzhengdxumsft_5-1711072622295.png

And add a bookmark named 'Group' :

vzhengdxumsft_6-1711072679615.png

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

vzhengdxumsft_7-1711072753035.png

Next, select bookmark navigator in the Insert pane:

vzhengdxumsft_8-1711072796540.png

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

vzhengdxumsft_9-1711072985181.pngvzhengdxumsft_10-1711072996517.png

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.

View solution in original post

3 REPLIES 3
v-zhengdxu-msft
Community Support
Community Support

Hi @ktt777 

 

Please try this:

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

vzhengdxumsft_0-1711072455953.png

Then add a column chart and a slicer

vzhengdxumsft_1-1711072500732.pngvzhengdxumsft_3-1711072530118.png

Select the bookmark in the View pane:

vzhengdxumsft_5-1711072622295.png

And add a bookmark named 'Group' :

vzhengdxumsft_6-1711072679615.png

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

vzhengdxumsft_7-1711072753035.png

Next, select bookmark navigator in the Insert pane:

vzhengdxumsft_8-1711072796540.png

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

vzhengdxumsft_9-1711072985181.pngvzhengdxumsft_10-1711072996517.png

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
Helper V
Helper V

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
Solution Specialist
Solution Specialist

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.

Bmejia_0-1711045211379.png

 

Helpful resources

Announcements
Fabcon_Europe_Social_Bogo

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.