Multiple dynamic filters for values in one table

[Anonymous]

Hi guys,

I have following table:

	MTD		YTD
	Team 1	Team 2	Team 1	Team 2
KPI1	80%	78%	78%	80%
KPI2	90%	95%	90%	95%
KPI3	100%	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

[v-yulgu-msft]

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