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.
I have a discrepancy with a figure (Breaches in 20/21) being displayed when I publish my report.
Here is how the figure is filtered:
Figure in PowerBI Desktop after refresh:
Figure when Published & viewed through browser:
And here is the dataset - I have a strong feeling its related to the four records which have a date identified as 1st April. There are 26 records which meet the criteria of 01/04/2020 -> 31/03/2021
As a temp fix I've amended the dates from 31/03/2020 -> 31/03/2021 - this displays the correct 26 figure.
Data is below....
Any help much appreciated - I'm stumped!
Hi @v-xulin-mstf afraid I've still not found a solution to the issue. See below, note how the dates highlighted change when published to the BI service:
In PowerBI Desktop:
In PowerBI Service:
I can see having scoured the forums that several people have had a similar issue but cannot see a solution that can be applied. If anyone can shed any further light I'd be really interested.
Thanks again,
Hi @stokidez
Please refer this method:
Best Regards,
Link
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
Thanks @v-xulin-mstf
I've read the blog and watched the video. I do not need to change time zone on a per user basis. I just need to change time zone when its published for all users by the same degree. It mentions a change to the DAX code to implement but doesn't specify. How would I achieve this please?
Hi @stokidez,
Is your issue that the custom data is not implemented properly in the service?
Best Regards,
Link
@stokidez , 1. Create browser cache, republish and check
2. Is there any time zone setting done at power bi service - refer: https://4pbi.com/resolving-timezone-issue-on-power-bi-service/
Thanks @amitchandak - it's not a caching issue as I've deleted cache/temp files, restarted etc.
The date field in question is a custom field where I'm forcing it to be local time. How would I amend this calculation to stop it being changed through the PowerBI service?
Thanks,
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 |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |