cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Helper I
Helper I

Show items with no data not working in a matrix

Can't figure out how to get around this problem.    Please see the attached PBIX file. 

 

https://1drv.ms/u/s!AsztPe4auCBSajopWhoJBWjonoI?e=TVOgTi       

 

if an item is not ordered in a particular month, there is no record for it in the Orders table.  For products ordered in the past, need to show a blank or a zero when the product was not ordered in a particular month.  Don't want to show all products if they were never ordered. 

 

Capture.PNG

 

Capture 2.PNG

3 REPLIES 3
Community Support
Community Support

Hi @Reetz ,

 

I checked your report and found no problems. The ‘Show items with no data’ option works normally.

Don't you want the kind of visual effect I marked?

v-lionel-msft_1-1595307901093.png

The matrix below turns on the ‘Show items with no data’ option on the ‘Year-Month’ field and the ‘Product’ field.

 

Best regards,
Lionel Chen

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

Thank you for your response.  The matrix you circled is fine if left unfiltered.  My issue is when you filter down to Mary Jones, the matrix only shows her Feb 2020 bike order.  I also need to also show Jan and March as either blanks or zero for bikes ordered .  That is where I am having difficulty.  Right not, it is confusing for our Customer Service Dept when they are looking up a customer.  They need to see  every month in the timeframe they are looking up if a product was ordered or not.   Hope that makes sense.

Capture.PNG

 

Hi @Reetz ,

 

The easiest way is to turn on the "Show items with no data" option on the [Year-Month] field.

v-lionel-msft_0-1596011898250.png

Can this meet your requirements? If not, please bring it up and I will follow it again.

 

Best regards,
Lionel Chen

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

 

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors
Top Kudoed Authors