How to modify my expression to force Vari % return as % ?

Question

Hi AllVijayP&nbsp;have share with me Advanced Card , This Vis is must better then PBI Card Visulisation.Because it can display more information in one card.&nbsp;&nbsp;When i try to use the below expression for display % Vari :-&nbsp;_Vari_%_REV = if(isblank( divide([_YTD REV]-[_LYTD REV],[_LYTD REV])),1, divide([_YTD REV]-[_LYTD REV],[_LYTD REV]))&nbsp;Can some one share how to modify the above to force it display as %&nbsp; ? Now it display as 12 decimal point.https://www.dropbox.com/s/f6lsud321sdk2wr/PBT_V2021_339%20ask%20how%20to%20modify%20the%20expression%20not%20display%2012%20decimal.pbix?dl=0Above is PBI file :-

mahoneypat · Accepted Answer

Select your measure in the Fields panel and then click on the % sign to format it as percent in the ribbon.&nbsp; Also, you should write that measure using a variable to keep it from calculating twice each time.
&nbsp;
_Vari_%_REV&nbsp;=VAR&nbsp;vResult&nbsp;=&nbsp;&nbsp;&nbsp;&nbsp;DIVIDE&nbsp;(&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;[_YTD&nbsp;REV]&nbsp;-&nbsp;[_LYTD&nbsp;REV],&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;[_LYTD&nbsp;REV]&nbsp;&nbsp;&nbsp;&nbsp;)RETURN&nbsp;&nbsp;&nbsp;&nbsp;IF&nbsp;(&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;ISBLANK&nbsp;(&nbsp;vResult&nbsp;),&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;1,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;vResult&nbsp;&nbsp;&nbsp;&nbsp;)
&nbsp;
Pat

Forum Discussion

How to modify my expression to force Vari % return as % ?

2 Replies

Related content

Help!!! Expression Error

Regular expression

LASTNONBLANK when expression only returns blank

Calendar Table returning error: The expression specified in the query is not a valid expression

Regular Expression Functions (REGEX) in Power Query