Forum Discussion

deepalsoft's avatar
deepalsoft
Regular Visitor
3 years ago

Remove Matrix value lines

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

 

 

 

Need Help

3 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      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.

  • Anand24's avatar
    Anand24
    Super User
    3 years ago

    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