Type of Graph based on a parameter

[mazwro]

Is there a way to change a type of a graph based on a chosen parameter?

I have data like the following:

Parameter1 with fields:

Number of Issues, % On Time completion, Number of Repeat Problems, Effectiveness %

Parameter 2 with fields:

Device Category, Priority Level, Unit, Location

And then I have a graph which shows metrics from param 1 split by groups from PAram 2. Problem is that Param 1 contains some % metrics which cannot be used on a stacted bar chart and I want to change the type of a graph to line chart if these two are clicked on.

Is this possible?

This is what the graph looks like now:

And I want to change it to the following if I pick param %On time completion or Effectiveness %

Can anyone help?

[v-sgandrathi · Accepted solution]

Hi @mazwro,
Thank you for reaching out to the Microsoft Fabric Community forum.

Yes, we can achieve this with bookmarks and we can be able to see line chart and bar chart  accordingly as you need.
I took sample data and performed the process by creating measures and adding new tables. Added both Line chart and Bar chart, slicers and then added Bookmarks. With bookmarks we can use slicers to visualize by switching.

For your convenience, I’ve attached the PBIX file with the implemented solution. Please review it and let us know if this steps works for you and reach us if there are any additional adjustments needed.

If this post helps, then please give us Kudos and consider Accept it as a solution to help the other members find it more quickly.

Best Regards,
Sahasra.

[Thejeswar]

Hi @mazwro ,

You can achieve this with Bookmarks. But don't think you can do it based on parameters.

You can only give an impression to the user that you are using parameters... But all the values have to be configured in the view itself

Regards,

[danextian]

Hi @mazwro 

100% possible with boomarks but with partly with parameters as you cannot use a slicer selection to switch between different visual types. However, you can use a line and column combo viz and hide either the line or the columns depending on slicer selection.   I said line in singular form because the combo chart doesn't accept legend for the line.