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.
Hi everyone,
I need some help with table visuals.
I am trying to build a year over year sales comparision at the customer level in a table visual. I have been able to achieve this in a column chart, using the years 2015 and 2016 as a legend, but can't figure out how to do so in a table.
My data is at the invoice level and appears as such:
Posting Date (day, month, year)/Invoice #/Customer #/Amount
I'm trying to build a table visual that dispalys:
Customer #/ 2015 YTD Sales/ 2016 YTD sales
Is this possible to achieve in a table visual using data that is at the invoice level? I did some research online and looked through the forum but didn't have any luck.
@Colin How you approach this depends on how you plan to visualize this information...
See picture... Let me know if either approach works for you.
Sean,
Thank you for the quick response! The second option looks perfect.
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 |
---|---|
112 | |
100 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
111 | |
92 | |
84 | |
66 |