Remove Blank Rows in Matrix

Hi Donerandparmo1 ,

Thanks for reaching out to fabric community.

I have created a power bi file based on my understanding. I have unpivoted the columns and calculated columns to represent the data.

If the file doesnot meet your requirements please let us know you query in details so that we will try to reproduce what you want.

Thanks!!

Please try this  similar post https://community.fabric.microsoft.com/t5/Desktop/Avoid-blanks-on-a-hierarchy-without-modifying-context/m-p/5214154#M1470310