Line graph from a four column table

[Anonymous]

Hello

My data is:

Product ID - Sales - Date - Type of Sales

A                -    5  - 01/01/20 - Retail

A                -    4  - 01/02/20 - Web

C                -    3  - 02/01/20 - Retail

etc

Where do I put each of these columns in a line graph so that I will show in the Sales per Date for each Product/Type of Sales pair?

The Legend field does not seem to be able to accept more than one columns.

Thanks!

[AlexisOlson · Accepted solution]

You can concatenate the ID and Type as a new calculated column and then put that column in the legend.

Product-Type = Sales[ProductID] & "-" & Sales[Type Of Sales]

Here's what that might look like using a modified version of the .pbix @rodrigosan provided (concatenated two different ways):

You could also consider using small multiples to get one of these options (no new column required):

[rodrigosan]

Hi, could you check if the solution suits you

https://1drv.ms/u/s!AjZuC23Tllhiy1IUgfAbEVa0mZd7?e=CkRsIL