card visualization formatting for dax

[Anonymous]

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]

@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 :

[VahidDM]

@Anonymous 

Can you share your PBIX file?

[Anonymous]

Hi @VahidDM 

Please download the pbix file : https://www.mediafire.com/file/s6rbjvj4cibkjjd/Example_1.pbix/file 

[VahidDM]

@Anonymous 

set 0 decimal like image below:

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]

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]

Hi @VahidDM 

i tried to change the format to #,##0;($#,##0) but still remain the same

[VahidDM]

@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/

[Anonymous]

Still can't :  

Active SKU = 
VAR _A= COUNTROWS(
    FILTER(
        RELATEDTABLE('Product'),OR('Product'[status]="active",'Product'[status]="")))

return
format(_A,"#,##0")

[TheoC]

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]

Hi @TheoC 

its not the category label.

I wanted 44006 to be 44,006

i tried using this it does not work 

[TheoC · Accepted solution]

@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.

[Anonymous]

it works thanks 🙂

[TheoC]

@Anonymous did you try the above?