Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Line graph from a four column table

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!

Need Help
  • AlexisOlson's avatar
    AlexisOlson
    4 years ago

    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):

2 Replies

  • AlexisOlson's avatar
    AlexisOlson
    Super User
    4 years ago

    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):