Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Solved! Go to 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.
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.
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:
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 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.
Proud to be a Super User!
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |