Waterfall chart - All date in filtred period in axis X

[pgromski]

Hi everyone,

I have a little problem with my conception 🙂  i.e. I have a chart with Axis X with date. I get date from date dimension where I have data from 2000 to 2030.

In chart I filtred data with slicer, e.g. one event and I see on axis date where I have data, but I'd like to see every day in this period.

Sample:

event: 2018-04-01 to 2018-04-07

data:

2018-04-01 - 24 pcs

2018-04-02 - 10 psc

2018-04-03 - 13 pcs

2018-04-06 - 10 pcs

2018-04-07 - 7 pcs

Currently or I see only 5 days or when I use "show item with no data" I see date from 2010 to 2030.

I want to see like this:

2018-04-01 - 24 pcs

2018-04-02 - 10 psc

2018-04-03 - 13 pcs

2018-04-04 - 0 pcs

2018-04-05 - 0 pcs

2018-04-06 - 10 pcs

2018-04-07 - 7 pcs

[v-shex-msft · Accepted solution]

Hi @pgromski,

I'd like to suggest you write a measure to instead original column who used as value.

For e.g. 

Original you use amount with summary mode 'SUM', write a measure total:

Total= Sum(Table[Amount])+0

Then you can simply use slicer to filter on specific range and display blank value as zero without setting 'show item with no data'.

Regards,
Xiaoxin Sheng

[pgromski]

Great!

Very simple solution. I didin't know this trick.

Thank you