Forum Discussion
card visualization formatting for dax
I would like to format this card visualization which is a Dax formula :
I tried to use the number format in the column tools and it does not work:
it should ideally look like this :
Anonymous Click on the measure and go to the ribbon and change the Format to "GENERAL" and use the comma.
If it automatically changes to a Decimal, then just go to the Visualizations pane and "Call Out Value" and put 0 in the "decimal" section.
Please give this a go.
13 Replies
Hi Anonymous
Are you wanting the measure to provide you with the answer 1,048,218? Or do you want the title on the card to go away? If it is the "Category Label" you want to disappear, just go to the Visualizations panel on the right and go to "Category Label" and switch it off 🙂
Anonymous Click on the measure and go to the ribbon and change the Format to "GENERAL" and use the comma.
If it automatically changes to a Decimal, then just go to the Visualizations pane and "Call Out Value" and put 0 in the "decimal" section.
Please give this a go.
Hi Anonymous
add #,##0;($#,##0) to your Format section.
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/Anonymous
maybe this:
Measure 2 = Var _A =COUNTROWS('Table')*12323123 -- add your formula here return format(_A,"#,##0")https://docs.microsoft.com/en-us/dax/format-function-dax
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/
VahidDM Tried changing to "General" and the comma
it will revert back to it to whole number but it didn't change the data.
if it is sum of the data then there is no issue :
but i need to count the number of stocks and it seems if I count the number of stocks I can't display it as 3,110 :Anonymous
Can you share your PBIX file?
Hi VahidDM
Please download the pbix file : https://www.mediafire.com/file/s6rbjvj4cibkjjd/Example_1.pbix/file
