Show items with no data - not working when slicers applied.

[Anonymous]

Hi,

I created a dashboard like this and "Show items with no data" is applied to the bar chart and the summary metrics.

In the first screen shot, I was able to review all months - eg. 2016-04, 2016-05, 2016-06, 2016-07, 2016-08, and etc.

As applying PART filter like the 2nd screen shot, 2016-06 and 2016-10 were missing.  I realize that both months have sum of zero and the event that I have is something like EVENT = SUM(table[freq]) + 0.

Could anyone tell me how I can make those months w/ zero events e.g. 2016-06 & 2016-10 display on the x-asix?

Thank you in advance!

[v-lili6-msft · Accepted solution]

hi,@lindseyhuang

     After my research, you can do these follow my steps as below:

Step1:

use Values function to create a table 

Table 2 = VALUES('Table'[Year month])

Step2:

Create the relationship between Table 2 and Table 

Step3:

Drag field Year month from Table 2 into Axis and set Show items with no data

Result:

here is pbix, please try it

https://www.dropbox.com/s/pb4ej8umprl8ma5/Show%20items%20with%20no%20data.pbix?dl=0

Best Regards,

Lin

[Anonymous]

Thanks for the response.  I love it.