plotting array time series data in power BI

[mali130]

Hi Folks,

I have follwoing dataset;

I am looking to draw the graphs on power BI to analyse the KPI numbers vs time. Its easier to draw in excel. But when i import the data in Power BI it treats the data as all columns, I want to make something like this;

Your help is much appreciated. 

[mali130]

Thanks Amit it was helpful 

[v-easonf-msft]

Hi, @mali130 

If your problem has been solved, please accept the helpful reply as solution to close this thread, so that other community members will easily find the solution when they get the same issue.

Best Regards,
Community Support Team _ Eason

[amitchandak · Accepted solution]

@mali130 , The weekday and date should be in the row for power bi .

To get this visual you need Concatenate Label - off, sort on axis (Dafault in Sep 2022)

Concatenate Label off : https://youtu.be/QgI0vIGIOOk