Forum Discussion

vutruong's avatar
vutruong
Icon for Helper I rankHelper 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 but red simbol. Can you please help figure it out how to do it.

 

Thanks for your help.

 

Regards,

Vu

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

2 Replies

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Icon for Microsoft Employee rankMicrosoft 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