Hide Blank Rows not whole result

[kpct56591]

I am still learning Power BI, but this has to be one of the most frustrating parts of it. I am trying to hide Case Spend and Total Case Spend when it is blank for an item, but still show the Ship Qty and Gross Sales. In the picture example attached, item 00 has no case spend, while item 0 does. If I use the visual filter to hide Case Spend when blank or 0, it hides all of item 00 and only shows item 0. I have tried measures and still get the same result. I just want to collapse the two empty rows and save some space in the report.

The visual is a matrix, item number and the whited out line are rows, the rest are values shown as rows. Columns are months.

[ajaybabuinturi]

Hi @kpct56591,
Coud you please try below measures 

1. Create new "MetricsName" table using "Enter Data" options.
   
2. Create measures like "Case Spend" and "Total Case Spend" if not created 
3. Create a new measure like below 

Matrix Value = 
SWITCH(
    SELECTEDVALUE(MetricsName[Metric Name]),
    "Ship Qty", SUM('Sales_Data'[Ship Qty]),
    "Gross Sales", SUM('Sales_Data'[Gross Sales]),
    "Case Spend", 
        VAR v = SUM('Sales_Data'[Case Spend])
        RETURN IF(ISBLANK(v), BLANK(), v),
    "Total Case Spend", 
        VAR t = [Total Case Spend]
        RETURN IF(ISBLANK(t), BLANK(), t)
)​

3. Add the fileds as shown below and switch values to rows. Then uncheck the "Show items with no data".   

Using above steps you will get required results.

Thanks,
If you found this solution helpful, please consider giving it a Like👍 and marking it as Accepted Solution✔. This helps improve visibility for others who may be encountering/facing same questions/issues. 

[kpct56591]

Hello, this returned the following error:

[ajaybabuinturi · Accepted solution]

Could you please provide me some sample data how your doing.

[v-aatheeque]

Hi @kpct56591 ,

we haven't heard back from you regarding our last response and wanted to check if your issue has been resolved.

If the response addressed by the community member for  your query, please mark it as Accept Answer and click Yes if you found it helpful.

[v-aatheeque]

Hi @kpct56591 ,

we haven't heard back from you regarding our last response and wanted to check if your issue has been resolved.

 If the response addressed by the community member for  your query, please mark it as Accept Answer and click Yes if you found it helpful.

Thank You.

[v-aatheeque]

Hello @kpct56591 

If the information is helpful, please accept the answer by clicking the "Upvote" and "Accept Answer" on the post. If you are still facing any issue, please let us know in the comments. We are glad to help you.

We value your feedback, and it will help us to assist others who might have a similar query. Thank you for your contribution in enhancing Microsoft Fabric Community Forum.

[pankajnamekar25]

Hello @kpct56591 

You can add visual level filter from filter pane for any numric feild is not blank

Thanks,
 Pankaj Namekar | LinkedIn

If this solution helps, please accept it and give a kudos (Like), it would be greatly appreciated.

[kpct56591]

Hello, the visual level filter hides 00 completely, instead of just the empty rows.