Forum Discussion
Labbel with previous year data
Hello, I'm new in Power Bi and I have some trouble making some DAX if you can help me be appreciate.
I have the following data.
And I'm showing it in a Bar Chart
Also, I have some labels that when you click in one bar show some data of that bar, but also I need to show in a label the shipment YTD of the previous year. I have a Year Column
If I click the bar of the season 2019-2020 March I need to see the value Shipment YTD of 2018-2019 March
Can you help me with the DAX
Thanks!
1 Reply
- Pragati11
Super User
Hi AgustinLopez ,
I wrote a blog sometime back in which I have shown previour year sales calculation.
When you click on a bar with current year sales, the card visual on the top shows the previous year sales.Link to the blog:
https://community.powerbi.com/t5/DAX-Commands-and-Tips/Labbel-with-previous-year-data/m-p/1543956
I think this will ive you an idea for your requirement.
Thanks,
Pragati
