Get X-Axis to display every hour in the day

[Anonymous]

Hi I have two clustered columns I want to display one below each other. These show total values for each hour.

However, if an hour doesn't have data, it doesn't show that hour.

For example, graph 1 might only have data from 06:00 to 21:00. Graph data has data from 00:00 to 23:00.

But I want both graphs to display all 24 hours in the day.

Is there anyway I can set the X-axis to display the 24 hours of the day, so you can compare the two graphs? I've tried "Show items with no data" but that's not working.

Thanks

[v-diye-msft · Accepted solution]

Hi @Anonymous 

You need create a new table with a column which is listing 0-24 hour, and then manage the relationship between your fact table. 

Then you can use the new column added above as X axis, and enable the "Show items with no data", I believe you can work it out!

[Greg_Deckler]

@Anonymous Try:

Measure =
  VAR __Calc = <some calc>
RETURN
  __Calc+0