Forum Discussion
Dynamically add or remove columns in matrix visual
SpartaBI I am not sure how this will work for my solution. I have pasted the visual below and here i want the counter column should be always selected. Example if i select application id then the matrix visual should show application id along with that counter column. How field paramter will help here? please let me know
Thanks
Vivek N
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