Forum Discussion
power bi chart with chart type change functionality ?
Hi Anonymous ,
If I understand correctly, your issue is that you want to change chart type at run time. Power BI does not natively support interactive chart type switching directly within a single visual, the following one can be used as a workaround by using bookmark with button:
1.You can create different chart visuals you want to switch between on the Power BI report canvas. Configure each chart as desired.
2.Going to the View tab and open the Bookmarks Pane and the Selection Pane.
3.With the Selection Pane, hide all but one of the charts.
4.Create a new bookmark. Repeat steps 3 and 4 for each chart type.
5.Insert buttons or images on the report that will serve as the triggers for switching charts.
6.Assign the appropriate bookmark to each button or image using the Action option in the formatting pane.
Looking forward to your replay.
you can try Bar Chart Run Time Convertible Scatter Plot from Office solution in Microsoft App store. https://appsource.microsoft.com/en-us/product/power-bi-visuals/officesolution1640276900203.bar-chart-run-time-convertible-in-scatter-plot?tab=Overview
In this chart users can change chart type at run time, This has many other features as well like Bar Chart Convertible in Scatter Plot by Office Solution helps users to convert Bar chart as Scatter plot chart or Column Chart at run time for better data analysis.
Key features:
1 Business users can change bar chart to Scatter plot chart for better analysis
2 Business users can change bar chart to Column chart for better analysis
3 Users can draw an additional Average line at each individual bar level or overall chart level
4 Users can compare individual KPI is going up or down in respect to another KPI
5 Business users can change X Axis dimensions/Measure dynamically at run time
6 Business users can change Y Axis dimensions/Measure dynamically at run time
7 Business users can change X Legends dynamically at run time
8 Business users can focus only top 5 or top 10 areas
9 Users can use an additional KPI which can be draw in the form of Icons at the last of bar with conditional formatting applied.