Forum Discussion

HenrikH29's avatar
HenrikH29
Icon for Advocate I rankAdvocate I
9 years ago
Solved

Show values as whole thousands

Is there a way to format visuals or tables to have the numbers shown in whole thousands.

 

The object is to make it more readable ie. "1.234" instead of "1.234.123" as i have a large number of values in some matix visuals.

 

Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    Ahh for a matrix, got ya.  For those i believe you'd have to write a measure that would convert the output for you.

     

    Maybe something like:

    Your Measure = ([Your Value] / 1000) & "K"

    You could add rounding in here too.

     

12 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Yes, quite a lot of visuals allow you to do that.  Look under the "Format" section of the Visualisation Settings.  In there will be sections relating to the various displays.  What you are looking for is an option called "Display Units" and "Decimal Precision".  These are typically defaulted to "Auto", but you can set it to "Thousands" and 0

    • HenrikH29's avatar
      HenrikH29
      Icon for Advocate I rankAdvocate I
      9 years ago

      Yes i found that in other visuals however i cannot find it in the new Preview Matix visual (the one with drill down functionality).

       

      I guess it's not an option in that.

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        9 years ago

        Ahh for a matrix, got ya.  For those i believe you'd have to write a measure that would convert the output for you.

         

        Maybe something like:

        Your Measure = ([Your Value] / 1000) & "K"

        You could add rounding in here too.

         

  • YourData_Guy's avatar
    YourData_Guy
    New Member
    2 years ago

    Select the metric --> Got to Format your Visual Option   --> Specific Column  --> Display Units --> Thousands/Millions/...

     

  • PeteD's avatar
    PeteD
    New Member
    4 years ago

    In 2021 showing thousands or millions etc is now just a format option on the Matrix. The accepted solution involving making measures is now obsolete. Is there a way to flag out of date questions and answers?

    • NonnaBlue's avatar
      NonnaBlue
      Frequent Visitor
      4 years ago

      I cannot find the option to format values as thousands in a Matrix.  Can someone post a screenshot of where that is?

       

    • calerof's avatar
      calerof
      Icon for Impactful Individual rankImpactful Individual
      4 years ago

      Hi PeteD ,

      Not closed for me. If we're using a matrix to show a series of measures and improve performance, instead of using multiple single card visuals, then the measures appear without rounding. If we fix a rounding to display units in millions for example, then when we change the period from YTD to MTD the value may not reflect a useful amount, just $0.0M. This feature to change automatically doesn't exist, correct?

      Regards,

      Fernando

      • nilimarodrigues's avatar
        nilimarodrigues
        Icon for Helper III rankHelper III
        4 years ago

        Agreed. The visual could show the data based on any value selected for a slicer. For eg. WW will have numbers in millions but looking at specific region/country through same visual, screws up the data labels.