Forum Discussion
Matrix Visual drill down from value grand total
Hi,
I'm trying to build a matrix with multiple measures on rows, with ability to drill down from them instead of first dimension I've placed on rows.
On the left my matrix, on the right what I'm trying to achieve. My intention is to put several more measures and add calculation groups on columns to show different time period.
- Anonymous4 years ago
Hello
I managed to solve it myself, by creating disconnected table with name of each measure and corresponding ID, and then using SWITCH function.
2 Replies
- lbendlin
Super User
This may not be possibe under rows. It can be done under columns.
Please provide sanitized sample data that fully covers your issue. If you paste the data into a table in your post or use one of the file services it will be easier to assist you. Avoid posting screenshots of your source data if possible.
Please show the expected outcome based on the sample data you provided. Screenshots of the expected outcome are ok.
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523- AnonymousNot applicable
Hello
I managed to solve it myself, by creating disconnected table with name of each measure and corresponding ID, and then using SWITCH function.