line chart using several data source

[Anonymous]

Hi guys,

i have an Excel files that contains a series of tab. Each tab is a different date and as 3 columns (data, value, date°
I would like to be able to show the value progress of each data over time.

This is one table

I tried creating some relationship but i did not manage to get the result i was after.
Note that in the futur i will be adding tabs to the same Excel file.

Thanks in advance for your help 🙂

[amitchandak]

@Anonymous , You can append all these tags into one table.

1. Append

2. Go to the first step of any tab query. You will see all tab name in a table. with expand icon on the column name. Use that these sheet will merge into one table

Or create common tables like date, Type etc, and join all tables with that.

If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.