I would love to utilize the Relative Date filter to handle things like current month, current year etc. However, when published up to the service, the relative date filter utilizes UTC timezone, and ...
This is a real issue for our company as well and it is an issue that can only be resolved by Microsoft. The only solutions/workarounds that are possible will either avoid using relative dates all together or will only fix the issue for a particular relative time frame. The largest similar Idea (most votes) that I have found is below, be sure to vote it up and raise an issue through your support contract. https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/32123752-power-bi-service-recognize-local-time-zone-for-tod
