Forum Discussion
Monthly X-Axis with Weekly Data on Line Chart
hi, Anonymous
Just turn off Concatenate labels in Formatting->X axis->Concatenate labels
Result:
By the way: Please ensure the chart sort by x axis values.
https://community.powerbi.com/t5/Desktop/concatenate-Labels-does-not-work-properly/td-p/415010
Best Regards,
Lin
Hi Lin!
The data is weekly - putting Month in the X-Axis summarizes the data, which I don't want. I'm looking to preserve the weekly data in the lines, while only showing months on the chart.
This is the summarized view that I want to avoid:The underlying data is weekly - this view summarizes the output (not ideal).
Community Supporthi, Anonymous
Drag WeekNum field into Axis as below, then Expand all and expand one field at a time.
https://docs.microsoft.com/en-us/power-bi/consumer/end-user-drill
Best Regards,
Lin
Hi Lin!
We are getting much closer! The output now shows month and Week Number, but the Months repeat. Is there any way to group them so it only shows the Month Name once per Month?Months still repeat...
Appreciate all the help!
- v-lili6-msft
hi, Anonymous
Just turn off Concatenate labels in Formatting->X axis->Concatenate labels
Result:
By the way: Please ensure the chart sort by x axis values.
https://community.powerbi.com/t5/Desktop/concatenate-Labels-does-not-work-properly/td-p/415010
Best Regards,
Lin
Hi Lin!
That works! Many thanks for all your help - both X-Axes needed to be numbers (I had been formatting the Month names as text with 'MMM' as the format). I was able to achieve the result by switching back to "Date Hierarchy" for the CalDates and Keeping the Week Numbers as categorical numbers. It looks great!