Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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!
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
User | Count |
---|---|
128 | |
109 | |
100 | |
65 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |