Forum Discussion
Accounting format in card visualization
Hello all,
I'm facing a simple issue here.
how to turn this total PO Value format into an accounting format, where it will be 5,933.63M.
Thank you in advance.
Anonymous
Select the measure or the column you need to format and apply the custom format given below:
Set the Display unit to None on the Data Label
#,##0,,.00 MHi, Anonymous
Please try the below.
Select display unit of the card visualization as Million
Manually type in #,##0.00 into the below red color area.
Hi, My name is Jihwan Kim.
If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.
Linkedin: linkedin.com/in/jihwankim1975/
Twitter: twitter.com/Jihwan_JHKIM
4 Replies
Anonymous
Select the measure or the column you need to format and apply the custom format given below:
Set the Display unit to None on the Data Label
#,##0,,.00 MHi Anonymous ,
Did you tried adding a comma separator highlighted in red below ? Just select the measure or column you are using and then click on the comma symbol highlighted in red.
Please accept this as a solution if your question has been answered !!
Appreciate a Kudos 😀
Anonymous , Not clear, do want to change display format, Usually each visual have option for that
Hi, Anonymous
Please try the below.
Select display unit of the card visualization as Million
Manually type in #,##0.00 into the below red color area.
Hi, My name is Jihwan Kim.
If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.
Linkedin: linkedin.com/in/jihwankim1975/
Twitter: twitter.com/Jihwan_JHKIM
