Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Custom axis limits on TIMEVALUE data

 have a stacked bar chart which uses a DAX calculater TIMEVALUE as the x-axis as follows:

 

StartTimeValue = TIMEVALUE(Meetings[localStartDate])

 

I have gone into Modelling and set the format of the data to TIME and using format of HH:mm:ss. If I look at the actual data it is displayed correctly.

However, depending on the filters I choose, the x-axis of the stacked bar chart changes based on the distribution of the data. I want to fix the x-axis to a 24-hour period: 00:00:00 -> 23:59:59. If I enter 00:00:00 in the Start box of the X-axis it goes red and is not accepted.

 

Any ideas on how to do this? What is it actually expecting in that field?

 

Thanks, Dave

 

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Interestingly if I set the format to date/time it shows the data as 30/12/1899 HH:mm:ss. Why such a wierd date?

  • v-lili6-msft's avatar
    v-lili6-msft
    Community Support

    hi,@banthorpe

          After my test, the result is negative values indeed.

    For your requirement, you could post your new idea in Power BI ideas and make this feature coming sooner.

     

     

     

    Best Regards,

    Lin