Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Monthly X-Axis with Weekly Data on Line Chart

Hi folks!   I have weekly data over multiple years that I'm trying to display in a line chart. The goal is to show one line for each year, with 52 data points intact, but on an X-Axis that only sho...
Need Help
v-lili6-msft's avatar
v-lili6-msft
Community Support
7 years ago

hi, Anonymous 

Just drag Month column into Axis and Year column into Legend.

 

If not your case, please share a simple sample pbix file for us have a test.

 

Best Regards,

Lin

Anonymous's avatar
Anonymous
Not applicable
7 years ago

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).

 

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      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!