Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Format string in Tabular Editor in Thousands

Hi ,   Can someone help me to figure out the format string ot use for the below : Current Format :  $8,255,064 Desired Format :  8,255 K   Thanks,   Deevs
Need Help
Tips and Tricks
  • v-janeyg-msft's avatar
    v-janeyg-msft
    5 years ago

    Hi, Anonymous 

     

    It’s my pleasure to answer for you.

    You may need to modify you date type in your model ,then try this in tabular editor:

    If it doesn’t solve your problem, please feel free to ask me.

     

    Best Regards

    Janey Guo

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

RobertSlattery's avatar
RobertSlattery
Responsive Resident
5 years ago

Still the same.  In the service as well as desktop.  And Analise in Excel.

RobertSlattery's avatar
RobertSlattery
Responsive Resident
5 years ago

Apologies: it does work.  For some reason the visual doesn't refresh when I make the change. When I change the formatting in desktop, I need to refresh the visual in the performance analyser (I don't want to wait for the ables to refresh).  This is true if I do it in Tabular Editor or directly in the pbix.  When I use Tabular Editor to change the published version, I need to shift-refresh the browser (which I should have realised!).

 

Thanks!