Plot multiple line charts with legend with grouped rows

[egenc]

Hello,

My intention is this:
1. Slicer takes year information as filter and filters the data. I will select a year to proceed. (This part is done)

2. As shown example below I filtered by 2024. After that, there are multiple versions with different values for each month of 2024. I want to plot one line chart with multiple lines (i.e if there are 6months of data - in that case there will be 6 lines)

Names of these lines will be grouped value such as 05/2024 and 06/2024 (legend - as months). I want to see value column on y axis, etl_row_version or etl_released_at in x axis and dates as line names as legend.

Any help would be great. Can anyone has any idea how to do this?

Here is a data sample:
date etl_row_version etl_released_at value flow_description granularity country_code
01/01/2024 00:00 1 17/01/2024 00:00 71.3243 SUPPLY monthly LATINAMERI
01/01/2024 00:00 2 15/02/2024 00:00 85.4631 SUPPLY monthly LATINAMERI
01/01/2024 00:00 3 13/03/2024 00:00 79.1234 SUPPLY monthly LATINAMERI
01/01/2024 00:00 4 11/04/2024 00:00 62.9085 SUPPLY monthly LATINAMERI
01/01/2024 00:00 5 14/05/2024 00:00 51.3297 SUPPLY monthly LATINAMERI
01/01/2024 00:00 6 12/06/2024 00:00 93.8742 SUPPLY monthly LATINAMERI
01/02/2024 00:00 1 17/01/2024 00:00 95.7841 SUPPLY monthly LATINAMERI
01/02/2024 00:00 2 15/02/2024 00:00 52.1549 SUPPLY monthly LATINAMERI
01/02/2024 00:00 3 13/03/2024 00:00 63.3712 SUPPLY monthly LATINAMERI
01/02/2024 00:00 4 11/04/2024 00:00 76.1984 SUPPLY monthly LATINAMERI
01/02/2024 00:00 5 14/05/2024 00:00 57.9448 SUPPLY monthly LATINAMERI
01/02/2024 00:00 6 12/06/2024 00:00 69.1179 SUPPLY monthly LATINAMERI
01/03/2024 00:00 1 17/01/2024 00:00 72.9925 SUPPLY monthly LATINAMERI
01/03/2024 00:00 2 15/02/2024 00:00 80.7645 SUPPLY monthly LATINAMERI
01/03/2024 00:00 3 13/03/2024 00:00 65.1091 SUPPLY monthly LATINAMERI
01/03/2024 00:00 4 11/04/2024 00:00 90.2018 SUPPLY monthly LATINAMERI

[Anonymous]

Hi @egenc ,

I seem to have misunderstood your requirements. Let's go back to the beginning, I copied your data and generated a line chart. We can see from the "Date" column of the sample data that it only contains data for January. Therefore, the "legend" of the line chart only has the January category.

Could you clarify what the line chart you expect is different from what I provided?

Best Regards,

Wearsky

[egenc]

Date type is DD/MM/YYYY so there is data for every month. I even extracted months in a seperate column and add as a legend but it didnt work. Any ideas?

[Anonymous]

Hi @egenc ,

Please try to create calculated columns.

Best Regards,

Wearsky

[egenc]

This didnt work. After Filtering data with slicer, I get this type of data:
date etl_row_version etl_released_at value flow_description granularity country_code month released_month
01/01/2023 1 17/01/2024 84.56 SUPPLY monthly LATINAMERI 1 Jan
01/01/2023 2 13/03/2024 75.32 SUPPLY monthly LATINAMERI 1 Mar
01/01/2023 3 14/05/2024 65.45 SUPPLY monthly LATINAMERI 1 May
01/01/2023 4 12/06/2024 90.11 SUPPLY monthly LATINAMERI 1 Jun
01/02/2023 1 17/01/2024 88.73 SUPPLY monthly LATINAMERI 2 Jan
01/02/2023 2 13/03/2024 66.21 SUPPLY monthly LATINAMERI 2 Mar
01/02/2023 3 14/05/2024 78.33 SUPPLY monthly LATINAMERI 2 May
01/03/2023 1 17/01/2024 92.56 SUPPLY monthly LATINAMERI 3 Jan
01/03/2023 2 13/03/2024 67.48 SUPPLY monthly LATINAMERI 3 Mar
01/03/2023 3 14/05/2024 85.76 SUPPLY monthly LATINAMERI 3 May
01/03/2023 4 12/06/2024 69.81 SUPPLY monthly LATINAMERI 3 Jun
01/04/2023 1 17/01/2024 71.09 SUPPLY monthly LATINAMERI 4 Jan
01/04/2023 2 13/03/2024 77.24 SUPPLY monthly LATINAMERI 4 Mar
01/04/2023 3 14/05/2024 63.39 SUPPLY monthly LATINAMERI 4 May
01/04/2023 4 12/06/2024 59.55 SUPPLY monthly LATINAMERI 4 Jun
01/05/2023 1 17/01/2024 94.87 SUPPLY monthly LATINAMERI 5 Jan
01/05/2023 2 13/03/2024 52.32 SUPPLY monthly LATINAMERI 5 Mar
01/05/2023 3 14/05/2024 68.74 SUPPLY monthly LATINAMERI 5 May
01/05/2023 4 12/06/2024 80.63 SUPPLY monthly LATINAMERI 5 Jun

I need to plot line charts of releasedmonth as legend and it didnt work. Here is what I tried and the result I get: