Forum Discussion
Help on Visualization
Hi Singh_Yoshi
Think of the Matrix visual in Power BI as being similar to pivot tables in Excel, rather than simple cell ranges. What you're trying to do isn’t supported out of the box. To implement this, you'll need to create a disconnected table that contains the column values along with their hierarchy, and then reference that table within a measure. This approach requires some additional modeling and isn't entirely straightforward and will take a considerable amount of time to develop. Please refer to the attached sample for more details.
Hi Singh_Yoshi,
I wanted to check if you had the opportunity to review the information provided by the community members. Thank you for the respnses. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank you.
Hi Singh_Yoshi,
As we have not received a response from you yet, I would like to confirm whether you have successfully resolved the issue or if you require further assistance.
If the issue has been resolved, please mark the helpful reply as a "solution" to indicate that the question has been answered and to assist others in the community.
Thank you for your cooperation. Have a great day.Hi Singh_Yoshi,
May I ask if you have gotten this issue resolved?
If it is solved, please mark the helpful reply or share your solution and accept it as solution, it will be helpful for other members of the community who have similar problems as yours to solve it faster.
Thank you.