Remove Matrix value lines

deepalsoft · ‎03-22-2023

Is it possible to remove selected matrix value lines but keep their subtotal figures as per the below image.?

Anand24 · ‎03-24-2023

Hi @deepalsoft ,
You can possibly achieve this by using "Per row level" subtotal settings.
Please play around with the below 2 circled properties in Format > Row subtotals to achieve what you need.

Give a Thumbs Up if this post helped you in any way and Mark This Post as Solution if it solved your query !!!

Proud To Be a Super User !!!
LinkedIn

deepalsoft · ‎03-23-2023

Anyone have an idea about that?

Anonymous · ‎03-24-2023

Hi @deepalsoft ,

According to your statement, I think you want to hide some result of [ExtraHour] in specific level in matrix visual.

As far as I know, Power BI current doesn't support us to achieve this goal.

I think [ExtraHour] should be a measure or a column in matrix value field. You can create a new measure with IF function to let it show blank when ID = 2022100.

Best Regards,
Rico Zhou

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