Forum Discussion

Pragati's avatar
Pragati
Frequent Visitor
9 years ago
Solved

Show values as whole thousands

 Hi, Is there a way to format visuals or tables to have the numbers shown in whole thousands. Example in below graph it should display Count of UniqueConfID as 61392 on top instead of 61k. As the val...
Need Help
Show and Tell
  • prateekraina's avatar
    prateekraina
    9 years ago

    Hi Pragati,

     

    Go to Data labels in Format pane of the visual and set Display units to None

    Refer below screenshot:

     

    Prateek Raina

prateekraina's avatar
prateekraina
Icon for Memorable Member rankMemorable Member
9 years ago

Hi Pragati,

 

Go to Data labels in Format pane of the visual and set Display units to None

Refer below screenshot:

 

Prateek Raina

  • rosirosss's avatar
    rosirosss
    Icon for Helper I rankHelper I
    8 years ago

    prateekraina Do you know how this can be done in an Infographic visual? i dont seem to find that option available

    • prateekraina's avatar
      prateekraina
      Icon for Memorable Member rankMemorable Member
      8 years ago

      Hi rosirosss,

       

      Check out this video. You will understand the steps to achieve that.

       

      Prateek Raina

      • rosirosss's avatar
        rosirosss
        Icon for Helper I rankHelper I
        8 years ago

        prateekraina thank you for your response. I watched the video but did not find what i was looking for. On the bar chart the data label is shown as 1.3 M or 2.4K. But i wanted it to be shown as 1,300,000 or 2,400. 

         

        I achieved what i wanted by adding a new measure. But I was hoping that infographic visual has some setting like the card with states visual (as you showed in your screen shot above) where you can format the data label.

         

        here is the measure i created - this will give me the metric value as 16,252 instead of 1.6 K

        MetricValueFormatted = FORMAT(sum(BPAT_Source[MetricValue]),"#,0")