Forum Discussion
Relative Hour FIlter
Hello!
I am working on an implementation with cosmos DB and PBI. I post data into cosmos every hour, and i´m trying to show this data into PBI.
I did a little bit but when I tried to apply a relative hour filter into my dashboard the relative hour take in count the UTC hour instead my historized hour.
My column "Hora" returns the last Hour that my sensors sincronize with cosmos DB. I would like to filter by the relative hour of sincronization or by relative actual hour but taking in count the UTC - 3 hours (that is my local hour) but i don´t have any column that return this data. How I could fix this?
In the next image I show how is the behaviour when I used the column "Hour" into the filter and how really is into a table.
That is my local actual hour.
And this if my local region configuration
2 Replies
- v-easonf-msftCommunity Support
Hi, Anonymous
If you mean that the relative date slicers take UTC+0 by default, I'm afraid there is no way to change that.
You can open a support ticket with MSFT to seek technical support , usually they may have better suggestions.
Best Regards,
Community Support Team _ Eason - AnonymousNot applicable
Oh that's disappointing. However, thanks for your reply!