Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Append Columns to a Matrix based on Measure Selection

I am curious if I would be able to have a table that only shows the columns if they are selected from a list of possible measurements.

 

I would create a table that shows the names of all the measures that would be possible to append to the table, and then I would create a slicer containing these measures. When a measure is selected in the slicer, it would append that selcted measure into the table and actually calculate it.

 

So for example if I wanted to see the total sales for each state, my table would already have the state names as the row as default, but the only way to display the column "sales" would be to select the measure "sales" from the slicer list of measure. 

 

Would this be possible? Any help is appreciated, thanks!