Forum Discussion

tim_001's avatar
tim_001
Helper I
2 years ago
Solved

Power BI - Matrix Visual - Issue with "Show items with no data" in the same Row

Hi, I am experiencing issues with the Show Items with No Data. 

 

I have a Product Name and underlying Product Numbers in a Matrix Visual under Rows. Under Values I have how many we have sold. For the Product Name I want to see also the ones with no Sales. So I click on "Show Items with no Data" for Product Name. But it also applies automatically for Product Numbers and shows all product numbers also from other Product Names that are not underlying the Product Name. 

 

It works when I move the Product Number to Columns and then I can only apply "Show Items with no Data" for the Product Name. But it does not look nice. 

 

Is there a measure or way to show the Product Name with no Sales but only the underlying Product Numbers?

 

Thanks a lot 

Tim

Need Help
  • Joe_Barry's avatar
    Joe_Barry
    2 years ago

    Hi tim_001 

    Maybe redo your Sales measure

    Sales =
IF(
   SUM(Sales[Amount]) = BLANK(), 0,
   SUM(Sales[Amount])
)

     

    Joe

     

    Did I answer your question? Mark my post as a solution!

1 Reply

  • Joe_Barry's avatar
    Joe_Barry
    Solution Sage
    2 years ago

    Hi tim_001 

    Maybe redo your Sales measure

    Sales =
IF(
   SUM(Sales[Amount]) = BLANK(), 0,
   SUM(Sales[Amount])
)

     

    Joe

     

    Did I answer your question? Mark my post as a solution!