if isfiltered then display sales for null values also

[avulasandeep]

HI Everyone,

If filtered the month in slicer then sales should be displayed for zero values also for example please find the screenshot below.
IF i select Month as 5 or 10  as in below picture there is no sales for product 5 and 6 but when we filter months 5 or 10  the output showing only product 10 and 11 only but my requirement is as shown in below pic.

if there is no sales then it has to display  zero value  in Table 

Thanks in Advance 
sandeep

[vivran22]

@avulasandeep 

Hi,

The trick is to restructure the data table:

So, now when you will use the slicer to filter the table, it will give you the desired result:

Hope this should answer your query.

Thanks,

Vivek

PS: I have used Excel but same can be replicated in PowerBI desktop.

Please mark it as accepted solution if it answers your query.

[avulasandeep]

Hi @vivran22
My question is this only when we are doing in desktop it not displaying blank values for not having product of sales and if the sales is blank need to show it as zero ....can you show it in PowerBI desktop ..for me it not displaying when we do filter

[vivran22]

@avulasandeep 

Here is the pbix file

Thanks,

Vivek

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

[avulasandeep · Accepted solution]

Hi the above pbix file is like static one and please refer below link as i need like this.

https://community.powerbi.com/t5/Desktop/If-we-select-date-in-slicer-display-sales-of-the-products-t...

I got solution.



Thanks
Sandeep

[avulasandeep]

Hi @vivran22
My question is this only when we are doing in desktop it not displaying blank values for not having product of sales and if the sales is blank I need to show it as zero ....can you show it in PowerBI desktop ..for me it not displaying when we do filter