Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

Column Visual YoY Comparison

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.

Community Champion
Community Champion

@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.

YoY by Customer.png


Frequent Visitor



Thank you for the quick response! The second option looks perfect.

Helpful resources

Power BI October Update 2021.jpg

Power BI Release

Click here to read more about the October 2021 Release!

Microsoft Ignite 768x460.png

Find your focus

Explore the latest tools,training sessions,technical expertise, networking and more.

Power BI Womens Summit 2021 768 x460.jpg

Interviews, learning sessions, allies, and more!


Teds Dev Camp Oct. 2021 768x460.jpg

Power BI Dev Camp - October 28th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!