Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Multiple dynamic filters for values in one table

Hi guys,

 

I have following table:

 MTD YTD 
 Team 1Team 2Team 1Team 2
KPI180%78%78%80%
KPI290%95%90%95%
KPI3100%98%99%99%

 

 

What I'd like to do is:

Set up 2 dynamic filters (slicers) - one showing years, another one months. With the 'year' slicer, I'd like to controll YTD part of my table (Team 1 & Team 2) and separatelly, controll MTD part with 'month' slicer. I need to have it dynamic, so the user can choose the value he / she needs - not in-built filtering within the table properties. Another prerequisite is that I need to have my data in one table as shown on the picture above.

 

Is it somehow possible? Could you please help me?

 

Many thanks

Need Help

1 Reply

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    7 years ago

    Hi Anonymous,

     

    How is the source data table like? And what do you mean "the user can choose the value he / she needs - not in-built filtering within the table properties"? 

     

    Based on my assumption, all data calculated for MTD and YTD is coming from the same table, right? And now, you want two separate slicer to control MTD and YTD separately. So, the selection in Year slicer should filter the result of YTD, while it shouldn't affect the result calculated by MTD, right? If that is the case, I'm afraid it is not achievable.

     

    Best regards,

    Yuliana Gu