Show full range on X-Axis of Bar Graph, even with 0 value data.

[Anonymous]

I've tried using 'Show items with no data', as well as a solution proposed in another thread:

Measure = 

  VAR __Calc = <Calculation>

RETURN

  IF(ISBLANK(__Calc),0,__Calc)

Neither of these options worked. Here is a screenshot of my calculation and screenshot.

This was my solution to show an hourly graph that (is supposed to) start at 6pm and end at 5am. This graph should start at 18 (6pm), but because the value for that time is 0, it's not showing up, but I need it to.

Thank you!

[tamerj1]

Hi @Anonymous 

please try

IF (

ISEMPTY ( 'Table' ),

0,

<calculation>
)

[Anonymous]

Hey @tamerj1 ,

Thanks for the suggestion, but it's showing the same result as when I used ISBLANK()

[tamerj1]

@Anonymous 

Apparently these records do not even exist in the data. Therefore you need a dim table that contains the full range (from 18 to 29)