How to modify expression to make it display 176K instead of display 176361.58 ?

[admin11]

Hi All

I just install Advance Card Vis , this card allow me to add more inform in one Card vis. 

however the prefix , does not allow me format Rev amount to make it display 176K instead it display 176361.68

_YTD REV = CALCULATE(CALCULATE(GL[AMOUNT],DATESYTD('Date'[Date],"12/31")), GL[1_REV] = "REV")

Hope some one can help me modify above expression , so that it will display 176K .

https://www.dropbox.com/s/e84nwphrjqbmd1c/PBT_V2021_339%20ask%20how%20to%20modify%20the%20expression...

My PBI file

Paul

[v-robertq-msft · Accepted solution]

Hi, @admin11 

According to your sample pbix file, it seems like that the “Data Lebel” setting can only apply to the “Prefix field” of the advance card chart.

Therefore, I guess that the only way to make it display 176K is to switch the place of the two measures in the chart.

Then I changed the measure [_Vari_%_REV_HONEY] like this:

_Vari_%_REV_HONEY1 =

VAR vResult =

    DIVIDE (

        [_YTD REV] - [_LYTD REV],

        [_LYTD REV]

    )

var _1=

    IF (

        ISBLANK ( vResult ),

        1,

        vResult

    )

return

FORMAT(_1,"Percent")

And I changed the fields in the advance card chart like this:

And I guess this can be what you want.

You can download my test pbix file here

Best Regards,

Community Support Team _Robert Qin

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[admin11]

@v-robertq-msft 

Now the % display with 2 decimal point. it there a way that i can make it display 0 decimal point ?

Paul

[v-robertq-msft]

Hi, @admin11 

Unfortunately, I can’t find a way to make it display 0 decimal point, because I used the Format() function to format the output of this meaure to Percentage and “Text” type, aiming to avoid the long string of decimals in the visual. But this function explains that the output will always two digits, like this:

More info about the Format() function in DAX

Best Regards,

Community Support Team _Robert Qin

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[admin11]

@v-robertq-msft 

you are supper good.

Paul

[negi007]

@admin11  please change the data lable settings as shown in the below picutre. I hope it resolve your issue.

[admin11]

@negi007 

Unfortune I am using Advance Card Vis , it does not allow me to set . 

[negi007]

@admin11 I have also used the Advance Card as below. if you are using any other visual, can you share the screenshot of which visual you are using, I am not able to download file from dropbox due to security restrictions at my end.