Forum Discussion
Power BI Line Chart visualisation with two columns in the X axis
RossRobinson , Make sure both Year and Month number. I was able to get similar stuff with this setting. But month was text and sorted on month no
Super UserHey RossRobinson ,
it's recommended not to say mandatory to use a dedicated date or calendar table inside your data model. This table then is related to the corresponding columns of the fact tables. Then the "month number" column can be used to create a chart like this:
This article covers almost everything about date related calculations in Power BI: https://www.daxpatterns.com/time-patterns/
This site provides a great introduction into the world of data modeling in Power BI: https://docs.microsoft.com/en-us/learn/modules/design-model-power-bi/
Hopefully, this provides what you are looking for, at least some ideas on how to tackle your challenge.
Regards,
Tom
Hi Tom, thank you, I will look into that. At the moment I am just experimenting so it will be ideal to compare how things worked before and after I get to the maturity level whereby I create the dedicated date table.
