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