Forum Discussion

kg_iconic's avatar
kg_iconic
Frequent Visitor
1 year ago
Solved

Date/Time Parameter drops Time portion of the string

I'm setting up a pair of parameters that are set to Date/Time. However, whenever I put a string in like 1/1/2024 12:00:00 AM and navigate away from the parameter (either to another parameter or by cl...
Need Help
  • OwenAuger's avatar
    OwenAuger
    1 year ago

    kg_iconic 

    Out of interest, are you still having an issue with this parameter?

    Here are a few things I would check if I were debugging this.

     

    1. Does the parameter behave as a valid datetime value when referenced by other queries?

    2. Could you post a screenshot of the Manage Parameter dialog box and the M code from Advanced Editor? I would expect something like below (with possible differences due to regional settings):

    #datetime(2024, 1, 1, 0, 0, 0) meta [IsParameterQuery=true, Type="DateTime", IsParameterQueryRequired=true]

    3. If you create another query by referencing the parameter directly, does it show the expected datetime value, similar to this?

    4. If you create another query to inspect the parameter's type, e.g. = Value.Type(Parameter), does it show datetime, similar to this?

     

    I've attached my PBIX in case that helps in any way.

     

kg_iconic's avatar
kg_iconic
Frequent Visitor
1 year ago

I've attempted all of these steps and to no success. 

v-achippa's avatar
v-achippa
Icon for Community Support rankCommunity Support
1 year ago

Hi kg_iconic,

 

Thank you for trying the suggested steps, 

  • Once check the Default Date formatting in Regional settings in power bi, temporarily switch the Local and restart the power bi and check if the issue persists.
  • Even though regional settings are fine some applications override them, so check the system level Date/Time formats and compare with your colleague’s system and make changes accordingly.
  • If possible i request you to please try the same PBIX file on a third machine to compare behavior, if the issue is still occurring.

If the issue persists, please check for any error messages and if possible please share the pbix file. let us know if you need any further assistance.

 

If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it! 

 

Thanks and regards,

Anjan Kumar Chippa