Forum Discussion
Dynamically add or remove columns in matrix visual
Community ChampionAnonymous now with the new field parameters feature it's really easy.
Just put all the columns you want to toggle on off in the field paramater table and the other column beside it on the table 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
- SpartaBI
Anonymous
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=5vLBnrPyPgcThank you for the quick response. I will try this solution and let you know if it solves my issue