Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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êsCovering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
96 | |
80 | |
68 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |