Forum Discussion

vbourbeau's avatar
vbourbeau
Resolver II
5 years ago
Solved

Line chart type continuous gray out

  Hi  look at the above graph. I use Year/WeekNum as X axis. It works ok but powerBi adds a scroll bar. I want to see it on one page? I know that the feature "continuous" on the X axis must d...
Need Help
  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    5 years ago

    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.

     

     

v-yalanwu-msft's avatar
v-yalanwu-msft
Community Support
5 years ago

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. 

vbourbeau's avatar
vbourbeau
Resolver II
5 years ago

Yes it's working but we get a gap between the weeknum 53 and 1, since we pass from 202053 to 202101.

 

  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    Community Support
    5 years ago

    Hi, vbourbeau ；

     Can you share a screenshot of your data date or share me with your pbix file after removing sensitive data. Because you could see from my pbix, the largest weeknum in 2020 is 53, So I'm not sure what your problem is.

     

    • vbourbeau's avatar
      vbourbeau
      Resolver II
      5 years ago

      I use your pbx. Look at the graph we get 202060 202080. But the week 60 and 80 didn't exist. A year only have 52 weeks.