X-axis weeks with numbers should show as continuous issue

[Anonymous]

Hello Team,

    I am having some issue with x-axis in one of my requirements. I have one line chart with weeks as X-axis and Sales as Y-axis with cumulative some for Sales. Here is an example.

   for week 0 sales are 11 millions
   For week 10 sales are 15 millions so we show total 26 millions in week 10 ....etc.

I have built some logic that calculates Cumulative summ and added week number to X-axis now it is working fine. But some issue is coming when add "Week" keyword to X-axis column and automatically converts to Categorical from Continuous and showing all week with scroling is coming.

I should show only 5 Weeks with lables Week 0, Week 10, Week 20 , Week 30 , Week 40 and Week 50 in X-axis without effecting cumulative sum. Please give me some ideas.

for some of refference 

[Anonymous · Accepted solution]

Hi @Anonymous ,

Create a independent week table and use it as x-axis.

Also modify the measure using weeks in week table instead.

Best Regards,

Jay