Forum Discussion
How to do dynamic column in a Matrix?
Hi All,
How do I add a column dynamically in a Matrix? Based on a slider value I need to show a column. For example if I have the sum of costs for a year determined by the slicer but at the same time in the matrix I want to show the previous years sum of costs how would I do that?
Thanks!
hi Anonymous
You could refer to this blog:
Dynamically change the information within a visual via a slicer
Regards,
Lin
3 Replies
- Greg_DecklerCommunity Champion
You can't really dynamically add columns to a matrix visualization. You can simulate it with bookmarks but that's about it. Measures and columns are either in a matrix or not.
- AnonymousNot applicable
Thanks for the prompt reply. Is there a way to do what I want with a column using a slicer? So if the slicer is says set to 2019 can the column do sums of the previous year?
Many Thanks!
- v-lili6-msftCommunity Support
hi Anonymous
You could refer to this blog:
Dynamically change the information within a visual via a slicer
Regards,
Lin