Forum Discussion

dpombal's avatar
dpombal
Post Partisan
9 months ago
Solved

timestamp custom format for milliseconds not working

Hi all I have a timestamp with precission of milliseconds even nanoseconds and in powerbi desktop this custom format is not working dd/MM/yyyy hh:mm:ss.fff   also tried with   dd/MM...
Need Help
  • Praful_Potphode's avatar
    Praful_Potphode
    9 months ago

    Hi dpombal ,

    Create a duplicate column(TradeTimestamp-copy) in power query and convert it into Text.

    Then in Table visual ,use the TradeTimestamp-copy for table visual.For sorting TradeTimestamp-copy column use original TradeTimestamp column.

    Sample PBIX

    Please give Kudos or mark it as solution once confirmed.

     

    Thanks and Regards,

    Praful

Praful_Potphode's avatar
Praful_Potphode
Super User
9 months ago

Hi dpombal ,

Create a duplicate column(TradeTimestamp-copy) in power query and convert it into Text.

Then in Table visual ,use the TradeTimestamp-copy for table visual.For sorting TradeTimestamp-copy column use original TradeTimestamp column.

Sample PBIX

Please give Kudos or mark it as solution once confirmed.

 

Thanks and Regards,

Praful

  • dpombal's avatar
    dpombal
    Post Partisan
    9 months ago

    for sorting do you use the original timestamp  or the number column you create?