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 👍
pbi_dot_edu Thanks for sharing the query. Could you please share the file with some sample data? Thanks!
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?
@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 👍
ghoshabhijeet I cannot thank you enough!! This solution worked exactly as expected. Truly appreciative of you taking the time to help me; I never would have thought to use that code.
pbi_dot_edu You're most welcome. 😊🙏
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.
