Matrix Visual Hide Subtotals when only one Row

[Anonymous]

I have an issue I have not been able to solve where I need to hide row subtotals when there is only one row to subtotal.  I have a DAX measure that returns blank for the rows I don't want subtotals on but the total row still exists.  I need to remove these rows to make the visual simple to read and understand by end users.  Any help would be greatly appreciated.  Turning on and off Subtotals at the row level does not work because I need them at the row level for some of the rows but not other rows when there is only one row to subtotal.  I need to remove the rows I have marked with red.Remove the rows boxed with red

[v-jayw-msft · Accepted solution]

Hi @Anonymous ,

It's not supported for Power BI currently, you may submit this as an idea through below link.

https://ideas.powerbi.com/ 

Best Regards,

Jay

[amitchandak]

@Anonymous , I doubt you can do it selectively