Forum Discussion
Dynamically add or remove columns in matrix visual
Hi, I have unpivoted a table to get the columns and values and used it in matrix visual. I have used the columns field in the slicer so users can dynamically select and remove particular column...
SpartaBI
Community Champion
Community ChampionAnonymous
You will basically put all the measures and columns you want to toggle on one parameter table and the counter column / measure will be a stand alone.
You don't built this on top of your current solution rather create it from scratch and then put in a table visual (not matrix) like the pic from my previous message. It's really easy to do that, takes a few minutes.
Not sure how to explain forther than what I showed you.
Did you watched some video about it?
https://docs.microsoft.com/en-us/power-bi/create-reports/power-bi-field-parameters
https://www.youtube.com/watch?v=-nqEv2YXLsU
https://www.youtube.com/watch?v=5vLBnrPyPgc
Thank you for the quick response. I will try this solution and let you know if it solves my issue