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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
UsePowerBI
Post Prodigy
Post Prodigy

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!

1 ACCEPTED SOLUTION
AlexisOlson
Super User
Super User

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

AlexisOlson_0-1635631945833.png

 

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

AlexisOlson_1-1635632019606.png

View solution in original post

2 REPLIES 2
AlexisOlson
Super User
Super User

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

AlexisOlson_0-1635631945833.png

 

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

AlexisOlson_1-1635632019606.png

rodrigosan
Resolver III
Resolver III

Hi, could you check if the solution suits you

 

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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.