Forum Discussion
MTD values for all months including current month when current year is selected
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.
2 Replies
- LivioLanzo
Solution Sage
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
- v-chuncz-msft
Community Support
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