Forum Discussion
Raki39
4 years agoHelper I
Custom 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 ...
amitchandak
4 years agoSuper 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
Raki39
4 years agoHelper I
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