Forum Discussion
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 surprised why I am not able to do in PBI.
I have attached :
1. PBI File
2.Excel File
3.Image Comparison between excel & PBI
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.
2 Replies
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 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.
