Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Number formatting for Q&A visual

Hi all,

 

So I have a Q&A visualisation that is able to show numbers based on what you ask it (E.g. What is the total revenue for Q3? It'll come up with a number like $398.88k)

 

My issue is how do I format this Q&A number and remove the two decimal, and have only three significant figures? So using the example above, instead of showing $398.88k it should simply show $399k.

 

I've been able to do this for other card visualisations using the "Data label" dropdown, then going to "Display units" under the visualisations section, however this option isn't present when using a Q&A visualisation specifically.

 

Please help!

  • Anonymous Try formatting your base column/measure for "Revenue" to be 0 decimal places.

2 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion

    Anonymous Try formatting your base column/measure for "Revenue" to be 0 decimal places.

  • v-kkf-msft's avatar
    v-kkf-msft
    Icon for Community Support rankCommunity Support

    Hi Anonymous ,

     

    Does your problem have been solved? If it is solved, please mark a reply which is helpful to you.

     

    If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.

     

    Best Regards,
    Winniz