Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Continuous & Categorial dates for Graph

Hi fellow Power BI workers 

 

I have a question about the x-axsis (date) for a graph. 

 

Requirement:

* The type of date I work with in PowerBI is "YearWeeknr" ex. 202347, 202348, ...., 202401 

* The date is a costum column that combines Year (string) and WeekNr (string)

NB: This is the best for my specific case, because im not interested in specific dates, only weeks.

* I only want to see Year and Week, I don't want a index-value for the "YearWeek" visualised in my graph. 

 

Complication

x-axsis (Date) as a continuous x-line 

 

  • As you can see there is a big gap between yearchange where there is no data, becuase it goes from 202352->202401 and 202452->202501.

X-axsis (Date) as a Categorical x-line

  • As you can see there a too many values visualised on the x-axsis 

 

NB: the two graphs above has the same values for x-axsis and y-axsis.

 

What im looking for:

Im looking for a solution that has continuous values for the x-axsis but without the gap between yearchanges.

 

Im looking forward to hear your solutions 🙂 

 

Best Regards 

PowerBI_Batman 

 

 

 

1 Reply

  • Anonymous , This issue as of now with YYYYWW and YYYYMM, you can use date if you want continuous axis