Forum Discussion

SuryaDave_Syd's avatar
SuryaDave_Syd
Regular Visitor
3 years ago
Solved

52 week line chart - not fitting all data

Hi All,  I am trying to create a line 52 week line chart in Power BI with axes showing weeks & months. However, chart is not showing properly.  I am able do that very easily in excel - so I am surp...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi SuryaDave_Syd 

    I changed the order of the x-axis

     

    Then you can click the expand all level icon of the visual on the upper right.

    Then you can create a measure and put it to the tooltip, then select sort by measure to sort the month of x-axis

    Measure = MONTH(CONVERT(SELECTEDVALUE(BaseData[Month])&" "&"1",DATETIME))

     

    Final output

     

     

    Best Regards!

    Yolo Zhu

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi SuryaDave_Syd 

I changed the order of the x-axis

 

Then you can click the expand all level icon of the visual on the upper right.

Then you can create a measure and put it to the tooltip, then select sort by measure to sort the month of x-axis

Measure = MONTH(CONVERT(SELECTEDVALUE(BaseData[Month])&" "&"1",DATETIME))

 

Final output

 

 

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

  • SuryaDave_Syd's avatar
    SuryaDave_Syd
    Regular Visitor
    3 years ago

    Anonymous  thank you very much ... really appreciate you taking the time out and helpming me. I think if we have such community support, PBI community will beat Tableau community in all areas soon. 

    Thanks again.