Custom Visualization for dynamically adding or removing the columns to a report

[Raki39]

HI,

I have a requirement where I need to give the customer a filter to dynamically add or remove the columns to the report. I don't have the control over the data to unpivot the columns and use the matrix visualization to acheive this requirement As, the connection we are using is a live connection (AAS service from which we are connecting to the power bi data sets).

Any work around or custom visualizations available to acheive this?

Thanks in Advance,

Raki

[Anonymous]

Hi @Raki39 ,

Believe that the option you need is to allow users to personalize visuals in a report:

https://docs.microsoft.com/en-us/power-bi/create-reports/power-bi-personalize-visuals

With this option active you can have user make changes on the visualization of:

• Change the visualization type
• Swap out a measure or dimension
• Add or remove a legend
• Compare two or more measures
• Change aggregations, etc.

This can be active at a single visualization level, at a page level or at a full report level.

Best Regards

Community Support Team _ Polly

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

[amitchandak]

@Raki39 , Dynamic axis, you can do using unpivot or bookmark, You can explore bookmark option

bookmark -https://blog.crossjoin.co.uk/2018/04/20/dynamically-changing-a-chart-axis-in-power-bi-using-bookmarks-and-buttons/
https://radacad.com/bookmarks-and-buttons-making-power-bi-charts-even-more-interactive

[Raki39]

Hi @amitchandak,

 Thanks you for the response.

 I cannot unpivot the data as the data modeling is done in the AAS. Bookmarks is also not a feasible option as I have 21 columns in report(table view) and adding and removing the columns should be dynamic.

Regards,

Raki39