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 all,
I'm trying to compare selled quant. of 2 different tables (2019 and 2020) but 2019 has all 12 month filled and 2020 just current (up to Jul.
This tables are avaliable online at a specific website by two different links (one for 2019 and other for 2020)
Below short versio of both table i'm trying to compare
At x axis I expect to see something like below but at this figure 2019 has data until Dec. and 2020 until Jun, but 2020 are live and current month this souce will be updated with Jul. data and keep going until Dec.
Both file are avaliable in:
2019 - http://www.anfavea.com.br/docs/siteautoveiculos2019.xlsx
2020 - http://www.anfavea.com.br/docs/siteautoveiculos2020.xlsx
table IV.
In resume:
How can I compare in a clustered column chart accumulate until current month in 2020 without download file and edit manualy?
Dataset isn't very Power BI friendly, I'd highly recommend familiarising yourself with Power Query to tidy it up. I've created you a sample file to show you how I'd go about getting that data into a bar chart.
https://1drv.ms/u/s!AnIEh6WhI4JogrAo8whZTRHeizC2XA?e=G84wf7
Thats great!
Your sample and how you work with data help me a lot.
I will work on this sample and do some tests, but seens to be what i need.
Thanks.
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 |
---|---|
117 | |
104 | |
77 | |
73 | |
50 |
User | Count |
---|---|
145 | |
109 | |
108 | |
90 | |
64 |