How to modify my expression to display 3% ?

[admin11]

Hi All,

I have below expression working fine :-

_YTD_NPM = DIVIDE([_YTD_NP_],[_YTD_REV_N]*1)

 it return 0.03 , may i know how to make it 3% ?

i try modify the expression like below :-

_YTD_NPM = FORMAT(DIVIDE([_YTD_NP_],[_YTD_REV_N]*1),%)

It does not work

Paul

 

[admin11]

@ryan_mayu Thank you for your suggestion , i have try , but i get error msg :-

[ryan_mayu]

@admin11 

pls try MAX the VAR column , not LY.

[admin11]

@ryan_mayu 

Very sorry I don't understand, can you pls explain in a bit more detail. 
paul

[V-lianl-msft]

Hi ,

To the best of my knowledge you can only return a single data type from a measure,Please try to use Tabular Editor:

https://community.powerbi.com/t5/Community-Blog/Using-a-slicer-to-show-different-measures/ba-p/17245... 

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

[ryan_mayu]

@admin11 

pls see the highlight part. It's differrent from the screenshot you provided.

IF(MAX(PNL_VAR)="7_NPM", DIVIDE([_YTD_NP_],[_YTD_REV_N])*100&"%",DIVIDE([_YTD_NP_],[_YTD_REV_N]*1))

[ryan_mayu]

@admin11 

pls try 

IF(MAX(PNL_VAR)="7_NPM", DIVIDE([_YTD_NP_],[_YTD_REV_N])*100&"%",DIVIDE([_YTD_NP_],[_YTD_REV_N]*1))

[amitchandak]

@admin11 , On the measure tool, there is a % symbol, press that and check, it should display 3%

[admin11]

@amitchandak 

Thank you for sharing , i try to click , but it still unable display % sign. As this expression is not directly display to table. it is past thru another expression.