Forum Discussion
Table visual - Is it possible to dynamically add/remove columns?
While this is somewhat along the lines of what I am looking for, I do need the ability to see more than the MAX() value which would mean that the table expands horizontally and vertically when more categories are added, and contracts when they are removed. There appears to be no native functionality in PowerBI to allow what I am looking for, so I am going to have to use bookmarks to achieve it. Thank you though.
Super UserAnonymous , You can replace measure values. Or you can make it blank. Using the meausre slicer.
measure slicer
https://radacad.com/change-the-column-or-measure-value-in-a-power-bi-visual-by-selection-of-the-slicer-parameter-table-pattern
https://community.powerbi.com/t5/Desktop/Slicer-MTD-QTD-YTD-to-filter-dates-using-the-slicer/td-p/500115
// With external tools you have some more flexibility
https://www.youtube.com/watch?v=vlnx7QUVYME
But to hide show, you need bookmarks
https://radacad.com/bookmarks-and-buttons-making-power-bi-charts-even-more-interactive