MTD values for all months including current month when current year is selected

[Anonymous]

Hi All, I have a scenario where we need to display KPI's and corresponding MTD values for all months for this year. I have created MTD values for the current month. Can anyone help me to get the MTD values for all months. Example: When the user checks the dashboard in June, the KPI and corresponding MTD values for Jan, Feb, March, April, May and June should be displayed. If the dashboard is viewed in November, KPI and all MTD values from Jan,---Nov should be displayed.

[v-chuncz-msft]

@Anonymous,

Take a good look at this discussion.

http://community.powerbi.com/t5/Desktop/Relational-Date-Filter-By-Other-Date-How-To/td-p/298373

[LivioLanzo]

Hi @Anonymous

You can add a slicer and use the Date column of your calendar table. Then on the top right corner you would choose 'Relative' and then choose This Year