Forum Discussion
Line Chart from Month Columns
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...
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.
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.
