Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Oh that's disappointing. However, thanks for your reply!
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
99 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
110 | |
91 | |
84 | |
66 |