Removal of additional information on axis

[Anonymous]

Dear PowerBI community,

I have created a time series chart to monitor the arrival rate of guests arriving into a venue. As you can see below, I am trying to run an interval of 5 mins. However, besides giving me the time, the axis is also showing me additional information (e.g. 30/12/1899). I tried several times to find ways to remove it but to no avail. Does anyone know how I can rectify this? Thanks in advance 🙂

[v-alq-msft · Accepted solution]

Hi, @Anonymous 

Based on your description, I created data to reproduce your scenario. The pbix file is attached in the end.

Table:

You may change the type of x axis as 'Categorical'.

Best Regards

Allan

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[lbendlin]

can you confirm that you have declared that column as type  Time, not as DateTime ?

[Anonymous]

Hi @BIBen ,

I just did a check and the time bin was based on the type 'time'. I did a try to change to text but it doesn't work. Do you know how I could resolve this problem?

[BIBen]

@Anonymous ,
I would love to help, but I am very inexperienced. I believe  you were trying to tag  @lbendlin