Forum Discussion
Removing Blank Rows from a Matrix Without Removing Group
@pbi_dot_edu Thank you for sharing the sample data. I have solved the issue and here is the link to the updated Sample data pbix file. Hope this helps. 😊
URL: https://drive.google.com/file/d/1C6p8GmjUP1gBhjofKNtYn_a3MdD6k-M4/view?usp=sharing** If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution, so that it comes in top of the search and help others. Thank you !
Good Luck 👍
Hi ghoshabhijeet ,
I am not able to upload a PBIX file but I have tried to export a link. Can you tell me if it works for you?
Hi,
You do not need those individual measures. Just drag the measure field to the row labels (below Category) and drag this measure
Measure = SUM('Query1'[Value])
Delete the measures that you wrote.
Hope this helps.