Forum Discussion
Line chart type continuous gray out
Hi , vbourbeau ;
If this is the case, you could set the Minimum category width and enlarged visiual width in visualizations as well.as following picture shows：
Because if it is a number type and it is not categorical, it will be arranged in numerical order, and the missing numbers will be filled in, so I think the above method is more appropriate.
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.
hi, vbourbeau ;
You could new a column by the following formula:
rank = RIGHT(YEAR([Date]),2)&"-"&IF(LEN(WEEKNUM([Date]))=1,"0"&WEEKNUM([Date]),""&WEEKNUM([Date]))then add it to x-axis; and sort by rank:
The final output is shown below:
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.
Still gets the scroll bar.
I notice that if the X axis is numeric the scroll bar disapear. But Power Bi short it by numeric order where is'nt what I'm looking for.
hi, vbourbeau ;
If you want the x-axis to be numeric, you can change dax to:
rank = CONVERT(YEAR([Date])&IF(LEN(WEEKNUM([Date]))=1,"0"&WEEKNUM([Date]),""&WEEKNUM([Date])),INTEGER)If it not solved, please provide me with more details about your problem or share me with your pbix file after removing sensitive data.
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.Yes it's working but we get a gap between the weeknum 53 and 1, since we pass from 202053 to 202101.
