Differences between Power BI service and Power Bi desktop, slicer filter (between) calendar

[wowcx]

I am seeing differences between the data of Power Bi desktop and Power Bi service, for example on the desktop I have dates between 1/11/2019 and 03/09/2020, but in the Power Bi service 11/1/2019 and 08/12 / 2020, how can I solve because I publish and re-publish and the result remains the same. Could you help me solve the problem, thank you very much.

[v-xicai]

Hi  @wowcx  ,

You may create measures like DAX below to get the Max and Min of Date in slicer visual for checking whether the Date have been changed.

MinDate=CALCULATE(MIN( Table1[Date]), ALLSELECTED( Table1[Date]))



MaxDate=CALCULATE(MAX( Table1[Date]), ALLSELECTED( Table1[Date]))

Do the suggestions from engineers make sense? If so, kindly mark the proper reply as a solution to help others having the similar issue and close the case. If not, let me know and I'll try to help you further.

Best regards

Amy

[wowcx]

Hi V-xicai, 

The problem is that the difference that i mentioned, is between the power bi service (online) and the power bi local (desktop), if it is the same, Why is the reason that slicer change?. A DAX formula, I don't know how much it can help me, thank you very much for the suggestion.

[AllisonKennedy]

Have you clicked the reset to default option for slicers?

The service will save your previous selections by default, not the slicer settings saved with the report, so if you click the reset filters yellow icon that should set it back to what you published.

[wowcx]

Hello Allison,
I have checked in the power bi service and the option that you mentioned is reestablished, so this does not solve my problem, thank you very much.

[AllisonKennedy]

Without getting my hands on both versions of the report I"m not sure how else to troubleshoot.

Are you more concerned about the different date formatting or the fact that the actual dates are different?