I am working on a table and creating drilldown in power bi matrix. Showing Drilldown From Member to To User. From member will drilldown to User and date. On the column header I see Instead of To User it shows First To User (red arrow). Second After drilling on the same line of From Member there is one of the To User (Blue arrow and yellow highlight) and next to it , it has SUM. Similarly at the bottom at TOTAL there is one To User Name and then SUM. My question is (1) how to remove First from the Fisrt User To. (2) How to remove Yellow Highlited Name . (3) How to remove name from the TOTAL row. Please see image for clarity. Thanks in advance for help.
2 Answers
Ans to question 1 Edit the column name as shown in the image. You can update it to any label you wants and the column header will show the label accordingly.
Ans to question 2 & 3 There is no exact configuration in Matrix for your scenario. In addition, adding Text column in the Values list also do not make that sense as you already facing issue with that column. In Matrix, Values column always considered for Aggregation and for Text type column you can take any of the option from - First/Last/Count. Now with those options, you can not achieve your required output.
Work around (Best for your case): This will solve your issue 1,2 & 3 together in one go. Create a Custom Column to your table as below-
date_user = your_table_name[Date] & " : " & your_table_name[user]
Now, add both your column From Member and date_user to the Matrix's Rows and Sale column to Matrix's Values property. The final output will be something like below (with my test data)-
====================================================
ADD USER DRILL DOWN
Add User(My Case Sub Category) column to Matrix row as below-
The final output will be as below-