Forum Discussion

filipe197's avatar
filipe197
Frequent Visitor
9 years ago

Trend arrows between series

Hello guys,

 

I am used to work with Think-Cell and this tool provide great analysis features. On Power BI, in my reports, would be great to display for example the differences of sales between years. Like this:

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Can any you figure this out?

Thanks!

Need Help

1 Reply

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Microsoft Employee
    9 years ago

    Hi filipe197,

     

    In Power BI desktop, there is no such a chart visual can show differences of sales between adjacent year like above image. As a workaround, you can create percentage values manually and add it into Tooltips section of a column chart.

     

     

    Last year = LOOKUPVALUE('Trend'[Value],'Trend'[Year],'Trend'[Year]-1)

    Diff = 'Trend'[Value]-'Trend'[Last year]

    percentage = 'Trend'[Diff]/'Trend'[Last year]

     

    Regards,
    Yuliana Gu