showing missing rows for each category for selected month in power bi

[Anonymous]

Two category with month/year wise sum of a value is showing.Some time while click on some month/year, the category wise  is not there..so it is showing without that row.ie..datavalue category is missing.

example

if possible to show the category on all the report months even if the value is $0.00?

[v-jingzhang]

Hi @Anonymous 

Have you tried the methods in previous replies? Could you please let us know whether they help solve the problem?

Best Regards,
Community Support Team _ Jing

[Applicable88]

@Anonymous you have to create a measure for that and at the end you add +0. Otherwise the normal behaviour of the table visual is to not show zero values.

For example:

Measure = sumx ( 'Sales', Sales [Value]) +0

Hope that helps. 

Best. 

[johnt75]

I think there's a couple of ways to achieve this. If you want the datavalue measure to return 0 instead of blank then you can wrap the measure definition in COALESCE and pass 0 as the second argument to COALESCE.

If you want the measure to return blank but still show up in the report visual, you can select a column in the Visuals well of the required visual and choose "Show items with no data"