Forum Discussion

vutruong's avatar
vutruong
Helper I
8 years ago
Solved

How to visualize % Changes like Stock Market chart

Hi,   I want to visualize % change in monthly sales  like charts in Stock market which has the red simbol in the beside the number. By using cart chart, I'm only able to visualize % changes ...
Need Help
  • v-jiascu-msft's avatar
    v-jiascu-msft
    8 years ago

    Hi Vu,

     

    You can try it like this. [Measure] is your current measure.

     

    Result =
IF (
    [Measure] > 0,
    CONCATENATE ( [Measure], UNICHAR ( 128314 ) ),
    CONCATENATE ( [Measure], UNICHAR ( 128315 ) )
)

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

    Best Regards,

    Dale

v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
8 years ago

Hi Vu,

 

You can try it like this. [Measure] is your current measure.

 

Result =
IF (
    [Measure] > 0,
    CONCATENATE ( [Measure], UNICHAR ( 128314 ) ),
    CONCATENATE ( [Measure], UNICHAR ( 128315 ) )
)

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Best Regards,

Dale