How to handle multiple columns in a line chart (without pivoting columns in Power Query)

[JohanSmith7]

Hi all, I need to replicate the following behaviour that is in a dashboard in QlikSense.

I have a filter that contains almost 20 options, each option selected should take 5 columns at the same time (Actual, Lag 0, Lag 1, Lag3, Lag 6) in my table and show a line graph using those 5 columns.

My data set looks like this: 

All of the previous columns should be grouped in some way with a label like: Total Demand. So when I select from the filter Total Demand, I should see the following: a line chart using the 5 columns.

The challenge comes when my data set is too large and it's almost imposible to think of unpivoting columns. In the past I have done the unpivot option from Power Query and I had my Atributes and Values to be used as desired and that worked fine in small data sets, now I have a table with +80M records and +150 columns  and there's +5 fact tables in my model.

I am looking for ideas, alternatives to overcome the previous challenge? is there anything I can do from DAX or even from table in SQL to have that behaviour in my dashboard?

Thanks,

[vk_pbi]

Is it possible to share some sample data as well as your data model..