Hello,
I am having issues trying to toggle what fields are visible in my matrix visual. I cannot share specifics about my data, but will give an example:
I have data sales by state by year. In my matrix, I have my rows as the year, my columns as the state, and I want to display 2 fields in my values field. 1, the sales by each state in each year. This is a non-issue. The other is a calculated measure, %YoY change. I wasnt users to be able to toggle whether or not they see this %chg value displayed in the matrix, but I am having issues figuring out how to do this.
I have already used a slicer to turn the values from visible to BLANK depending on if "Show %chg" is selected as "Yes". However, I would ideally like for a way to completely remove that from visibility in the matrix, instead of just having a blank values column. Is there any way to do this?
Thank you
