exclude particular row subtotal from matrix

[NISHA_S]

I am creating a table using a matrix visualization in Power BI.Here i want to remove total from Frame  Value  if the Frame contain only one set of row value like in first image...If the row contain more than one row under construction type then total values row also need to be displayed....like in 2nd image...Is it possible?

[v-cazheng-msft]

Hi @NISHA_S 

Unfortunately, Power BI currently does not support the complete removal of particular subtotal row. You can create Measure to display values of this row as Blank but the subtotal row will always exist. You can post your idea in Power BI ideas. Power BI will likely implement this feature in future versions.

Best Regards

Caiyun Zheng

Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.