Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Filter matrix table with slicer

Hello,

 

I want to filter the measures placed in the matrix table based on slicer selection. As you can see below in the matrix table I have placed 8 different measures which are been calculated on 2 different columns one column is SG&A and the other one been G&A.

 

Now what I am trying to achieve is that if the user select's G&A in the slicer, he/she should only see the measures which are built on G&A column i.e. Q1_G&A, Mean_G&A, Median_G&A & Q3_G&A, and other with SG&A when SG&A is selected in slicer

 

Also attached is the snippet of the data in the report.

 

Is this possible to do? If not, can I get it done by using bookmarks i.e have 2 different matrix tables and based on the slicer selection show the related matrix table?

 

amitchandak Could you please help me with this?

Thanks & Regards,

Saket

 

 

Need Help
  • Icey's avatar
    Icey
    5 years ago

    Hi Anonymous ,

     

    I create a simple example. Please check the attachment.

     

     

    Best Regards,

    Icey

     

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

2 Replies

  • VijayP's avatar
    VijayP
    Community Champion
    5 years ago

    Anonymous 
    Create a Sepearte Dummy Table Containing G&A and SG&A (Column Name Say "Type", Table name "Category")
    Use SELECTEDVALUE To Create a Trigger eg., =SELECTEDVALUE(Category[Type]).
    Then use SWITCH Function to get the required values 

    =SWITCH(TRUE(), [Selection]="G&A", only G&A Measure else SG&A Measure)
    Hope this Helps!

  • Icey's avatar
    Icey
    Community Support
    5 years ago

    Hi Anonymous ,

     

    I create a simple example. Please check the attachment.

     

     

    Best Regards,

    Icey

     

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