Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
I have a number of sales reports that use matrix and use the drill down feature.
For instance, a report has Items Families with drill down to Items with YTD sales etc. Likewise Territory drill down to customer.
User wants to see both code and description for items, customers etc.
Is there a way to address this without creating a column concatenating item number with description etc?
Solved! Go to Solution.
Hi @sanimesa,
You can add both to your rows, they will not appear both until you do the drill down but after that they will show side by side, the only question is if you have more than one item description for Item number of vice-versa since they will be on stair like mode:
Regards
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @sanimesa,
If you are on the matrix visual you need to select the drill down option to full extent check this tutorial with a full explanation on how to achieve it.
Regards,
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em Português@MFelix Perhaps my description was not very clear, I am not talking about drill down.
Here are my items:
Item Number Item Description
123 Pipes
124 Screws
In my matrix visual, I can add Item or Item description to rows, but not both. Adding both produces undesirable results. Wondering if there is a nicer way to do this without having to create a concatenated column.
Hi @sanimesa,
You can add both to your rows, they will not appear both until you do the drill down but after that they will show side by side, the only question is if you have more than one item description for Item number of vice-versa since they will be on stair like mode:
Regards
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsUser | Count |
---|---|
77 | |
77 | |
68 | |
67 | |
49 |
User | Count |
---|---|
108 | |
105 | |
93 | |
83 | |
64 |