Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
admin11
Memorable Member
Memorable Member

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

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 .
1 ACCEPTED SOLUTION
v-robertq-msft
Community Support
Community Support

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.

v-robertq-msft_0-1614579869632.pngv-robertq-msft_1-1614579869640.png

 

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:

v-robertq-msft_2-1614579869645.png

 

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.

View solution in original post

7 REPLIES 7
v-robertq-msft
Community Support
Community Support

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.

v-robertq-msft_0-1614579869632.pngv-robertq-msft_1-1614579869640.png

 

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:

v-robertq-msft_2-1614579869645.png

 

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.

@v-robertq-msft 

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

Paul

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:

v-robertq-msft_0-1614587843596.png

 

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.

@v-robertq-msft 

you are supper good.

Paul

negi007
Community Champion
Community Champion

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

 

 

negi007_0-1614428925508.png

 




Did I answer your question? Mark my post as a solution!
Appreciate your Kudos



Proud to be a Super User!


Follow me on linkedin

@negi007 

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

negi007
Community Champion
Community Champion

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

 

negi007_0-1614431857719.png

 




Did I answer your question? Mark my post as a solution!
Appreciate your Kudos



Proud to be a Super User!


Follow me on linkedin

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.