Date label not starting on the first data point on x Axis

[jovendeluna21]

Hello,

Anyone who knows how to show the data label on the first data point on x-axis?

I have attached here my pbix

https://drive.google.com/file/d/1wZy2RGIyRB4D-_QLRYe_Erw2F72pPxyS/view?usp=sharing

Thank you!

[Anonymous · Accepted solution]

HI @jovendeluna21 

PFA the modified Pbix.

1. Axis has to be Date type.

2. Use date hierarchy as in below screenshot.

3. Use the arrows as highlighted in below screenshot for the hierarchy you need.

[jovendeluna21]

how did you that date to have calendar icon? I guess that is the way in order for the other chart to have date hierarchy as well

[Anonymous]

Hi @jovendeluna21 ,

As checked your pbix file, there are some relationships created between Calendar table and State Data base on date fields. So date field in State Data will not display calendar icon and date hirerachy... You can get more details in the following threads.

Why no date icon and hierarchy?

[BUG/GLITCH?] Relationships from Calendar Table glitches out Date Fields in Fact Table

And as @SpiroswayGR suggested, you may change the date for Start textbox as "1/1/2020 12:00:00" and check whether can get what you want.

Best Regards

[jovendeluna21]

For the first chart that will work, however for the second that will not. Can you try also the second one? Thanks!

[Anonymous]

HI @jovendeluna21 

PFA that includes the 2nd chart too.

[SpiroswayGR]

@jovendeluna21 

Maybe you should change the auto dates and select specific especialy on start.

[jovendeluna21]

I have tried already but still now showing up

[SpiroswayGR]

@jovendeluna21 

Change also END date in future date.

It doesn't work only with start date.

[jovendeluna21]

Does not work as well

[SpiroswayGR]

@jovendeluna21 

Is this data table connected with Calendar table ?

[jovendeluna21]

Yes it is.

[SpiroswayGR]

@jovendeluna21 

I just downloaded your pbix and it worked well for me

I am not sure why is not updated but refresh data and check it again.

[jovendeluna21]

it surely work when you stretch the chart, however I need the original size of the chart. In one page 16:9 size must have 8 charts.