Report about missing data.

[Anonymous]

Hi there,

I have a report with 10 states out of which 3 states have data. I would like to provide information and metrics about the remaining 7 states (states that have no data). However PBI currently shows only the data about the 3 states. I'm missing something. Looking for tricks to report on details about rest of the 7 states (which does not have data).

I have uploaded report to git where work place allows. let me know if you have issues in accessing it. Dont have access to dropbox or other online storage links.

Download report only 1 pbix is available.

https://github.com/ArtiAshu/dummy/blob/2edea9eb4e00a41325231803ded0be947a4d926e/MISSING%20DATA%20REP...

Report Name

MISSING DATA REPORT - Copy.pbix

Thanks for your time.

[Anonymous]

Thanks Pat and others. I was able to figure it out. 

[ppm1 · Accepted solution]

You can choose "Show Items With No Data" on your Region field.

Pat

[Anonymous]

Thanks Pat. That helps.

Update: I was able to figure it out. I had achieve it by 2 step process. Do a left join and then create calculated column within the same table instead of referencing across tables. 

Not sure if you got a chance on the pie. The value should be 7 instead of 10. 

I tried to reference something like below to create a calculcated column on "Data" but not able to reference the relation from other table.

StateWithWithoutData = if(Data[StateCD] = states[StateCD],"withData","WithoutData")