Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
96 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
88 | |
63 |