Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
39 | |
21 | |
21 | |
14 | |
13 |
User | Count |
---|---|
44 | |
32 | |
30 | |
18 | |
17 |