Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Filter Out Entire Columns in Matrix

I have built the following matrix. 10% Goal and Achieving Goal columns are calculated columns. I would like to be able to filter out the AMER, APAC, and EMEA columns by some type of splicer. An example, I would like to only display AMER and EMEA columns (or any combination of AMER, APAC, and EMEA columns) and have the calclated columns reclaculate off of that data. 

 

Need Help

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi Anonymous 

     

    I believe you could add a slicer to your report with the category you want to filter.

     

    I'm not sure if that is what you're looking for but you can give it a try.

     

    Daren

  • v-joesh-msft's avatar
    v-joesh-msft
    Icon for Solution Sage rankSolution Sage
    6 years ago

    Hi Anonymous ,

    I'm a little confused by your description. In your matrix visual, AMER, APAC, EMEA, 10% Goal and Achieving Goal should be different values in the same column, so 10% Goal and Achieving Goal should not be calculated columns. Could you share your expected output?

    Best Regards,

    Community Support Team _ Joey
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.