show all dates on bar chart (also with zero values)

[Anonymous]

Hi guys,

i have a revenue bar chart per day. On some days i don't have revenues but i still want to show the date data points:

For the 15. Apr it's fine but the dates go up until the 25.04.2020. How can i blend them in aswell?

Thank you!

[v-alq-msft]

Hi, @Anonymous 

Based on your description, I created data to reproduce your scenario.

Table:

You may create a measure as below.

Revenue Measure = 
IF(
    ISBLANK(SUM('Table'[Revenue])),
    0,
    SUM('Table'[Revenue])
)

Result:

You may also try to click 'Visualizations'=>'Format'=>'X axis' and set as below.

Best Regards

Allan

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

[Anonymous]

Thanks! Works perfectly

[az38]

Hi @Anonymous 

for this purpose you need to create a calendar table like

Calendar = CALENDARAUTO()

the create relationships between Calendar and your fact table by Date field, then put Calendar[Date] field to visual as X-axis