Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Colin
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.

2 REPLIES 2
Sean
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

 

Colin
Frequent Visitor

Sean,

 

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

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors