Slots of time to plot on X-axis in 12-hour format

[rajulshah]

Hello,

I want to show a graph as follows:

That is, I want to see time with the format(12-hour format) as in the above image in X-axis.

Also, I don't want to see 0's as labels on the chart, but I want the value on X-axis to be shown with blank value.

Any help would be great.

Thanks in advance.

[v-xicai]

Hi @rajulshah ,

For your two demands, it is not supported to implement in Power BI currently .There is an idea about 12-hour format issue, please vote it up, field-of-duration-type, and you can post your new idea about showing blank intead of 0 as data label here https://ideas.powerbi.com/forums/265200-power-bi-ideas , to improve the Power BI.

It is a place for customers provide feedback about Microsoft Office products . What’s more, if a feedback is high voted there by other customers, it will be promising that Microsoft Product Team will take it into consideration when designing the next version in the future.

We also submitted this feedback to the product group internally, so that the product group can pay attention to this problem and speed up the issue repairing.

While to work around the first issue, you may create new calculated time table using DAX below, change the data type of time value to Time, then you can use the time value in your visual and calculation formula.

Time = SELECTCOLUMNS(GENERATESERIES( 0,TIME(23,0,0), TIME(1,0,0) ),"Time",[Value])

Best Regards,

Amy

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

[rajulshah]

Hello @v-xicai,

Thanks for the response. But the workaround you suggested doesn't meet my requirements.

Anyway, thanks.