Forum Discussion
pbi_dot_edu
1 year agoFrequent Visitor
Removing Blank Rows from a Matrix Without Removing Group
Hello all, I have a matrix visual that currently looks like the following: Metrics 1-5 are separate measures and I have selected "Switch values to rows". The issue I am having is th...
- 1 year ago
@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
1 year agoFrequent Visitor
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.
ghoshabhijeet
1 year agoSolution Supplier
pbi_dot_edu You're most welcome. 😊🙏