Skip to main content
cancel
Showing results forย 
Search instead forย 
Did you mean:ย 

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

Reply
Anonymous
Not applicable

Need help with matrix table.

Hi All. So I am using a matrix table in my report like below:

PRI123_0-1669359084908.png

 

As we can see in the above picture, Account Manager - 'Aaron Siler' has 2 Opportunities, 2 opportunity values, 2 Accounts and 2 confirmation dates. Likewise Each account manager would have 'N' number of opportunities, opportunity values, accounts and confirmation dates.

So my question is, Is there a way where we can show the very first opportunity, opportunity value, account and confirmation date and the other opportunities and etc information will be shown only if the user expands them using '+' icon? Is this achievable? Any help would be much appreciated. Thank You in Advance!

3 REPLIES 3
NikhilChenna
Contributor III

Hi @Anonymous ,

 

As per the screen shot given by you the drill mode is on so you are able to see all the values.

For showing only the first one you can simple click on the drill up button which will be on the top right of the visual as shown below,

 

NikhilChenna_0-1669360705588.png

 

You'll get your output from this.

 

Regards,

Nikhil Chenna

 

Appreciate with a Kudos!! (Click the Thumbs Up Button)
Did I answer your question? Mark my post as a solution!

Anonymous
Not applicable

hi @NikhilChenna It is drilling up the entire column 

Hi @Anonymous , 

 

Can you send me you pbix sample.

 

Regards,

Nikhil Chenna

Helpful resources

Announcements
Users online (27)