Line Chart from Month Columns

[fahadqadir3]

I have data of visits by month in the form of separate column for each month for example (screenshot): Monthly visits .2022-07-01, 2022-8-01,2022-09-01. 

I need to display these column values as line chart not bar chart. I try and apply pivot functionality to convert these columns as one separate Month names but my other values becomes wrong. For example, I also need to display bounce rate column in seaparate table/matrix visual, but when I try pivot and create line chart for my months column my other column values aure duplicated. Power BI .pbix file attached.  Line chart and table should display like this:

But power bi not allowed me to create line chart from months column and display charts and table like this;

Link to the file 

https://drive.google.com/file/d/1WMrf3ddeHXONnito4f4dmWEG0efO_Li0/view?usp=sharinghttps://drive.google.com/file/d/1WMrf3ddeHXONnito4f4dmWEG0efO_Li0/view?usp=sharing 

https://drive.google.com/file/d/1WMrf3ddeHXONnito4f4dmWEG0efO_Li0/view?usp=sharing 

[v-yalanwu-msft]

Hi, @fahadqadir3 ;

I try it , The best way is to unpivot it in Power Query, and for duplicate values, you can use metrics to calculate the correct deduplicated value.
Or you could change the averge of value as per month.

Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[fahadqadir3]

@v-yalanwu-msft  can you please share the file. I unpivot the columns but how I removed duplicate values of other columns ? how i calculate metrics ? please help.

[fahadqadir3]

@amitchandak 

@Jihwan_Kim 

Can you Please help