card visualization formatting for dax

[Garyhb]

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 :

[Garyhb]

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

@Garyhb 

Can you share your PBIX file?

[Garyhb]

Hi @VahidDM 

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

[VahidDM]

@Garyhb 

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

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/

[Garyhb]

Hi @VahidDM 

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

[VahidDM]

@Garyhb 

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/

[Garyhb]

Still can't :  

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

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

[TheoC]

Hi @Garyhb 

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 🙂

[Garyhb]

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]

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

[Garyhb]

it works thanks 🙂

[TheoC]

@Garyhb did you try the above?