Forum Discussion
Helper ICustom Visualization for dynamically adding or removing the columns to a report
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
3 Replies
- amitchandak
Super User
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
Raki39Hi 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
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.
