Line Chart X asix cannot maintain continuous type

[zealotworld]

Hi there,

I need 4 data in a line chart: 1 date, 2-week number, 3 value and 4 provider with the following setting:
X-axis with date and week number, Y-axis with value and separate with provider legend.

The line cannot maintain continuous type when I put all the data together. Please see the images below, the continuous type is only maintained when 3 out of 4 data are selected.

I have been trying for a couple of hours and cannot find a solution. Is there any suggestion?

[parry2k]

@zealotworld when you are looking at the data at the date level with provider, seems like not all the provider has data for each date and that's why you are not seeing the continuity, having said that when you remove the provider, the data for all the provider aggregated and it gives that it is a continuous line.

A simple way to test is, to create a matrix table, use date on rows, provider on column, and value on values, and you will see some of the providers will not have data for certain dates and that's what you see in the line chart.

👉 Learn Power BI and Fabric - subscribe to our YT channel - @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤️

[parry2k]

@zealotworld continuous type only works if the column is of type date and number, if it is a text it will not work.

👉 Learn Power BI and Fabric - subscribe to our YT channel - @PowerBIHowTo

[zealotworld]

Hi @parry2k , the data type for column [Date] is Date type and column [Week] is a whole number already. 

[MFelix]

Hi @zealotworld ,

Where are you getting this hierarchy from is it from the fact table or are you using a calendar table? 

It seems to me that you have missing dates values on your model so it does not return continuous data.

[zealotworld]

Hi @MFelix , X axis is from the calendar table that contains a continuous date and week number.
I am very confused because the continuous line works for
value + week + legend
value + date + legend
value + week + date
but not
value + week + date + legend