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.
When you add the "ProductName", "ProductID", and "Address" fields to the Rows section of the Matrix visual, by default, Power BI will treat them as hierarchical levels and display them with a drop-down behavior. This means that when you have multiple values for these fields, they will be grouped and displayed with a "+" or "-" icon to expand or collapse the groups. How to remove this drop-down behavior and show all the unique combinations of "ProductName", "ProductID", and "Address" as individual rows?
I want to show the matrix like this
ProductName | ProductID | Address | 1 - 10 | 11 - 20 | 21 -30 | 31 - 40 |
A | 12 | 3245 A st | $12 | $54 | $34 | $21 |
B | 32 | 1123 B st | $65 | $34 | $27 | $98 |
Solved! Go to Solution.
Hi @Sayesd ,
If you click the + button you will opewn the hierarchy has you need in the example below I have turn off stepped layout and +/- buttons the drill can also be done using the buttons highlithed
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @Sayesd ,
On the options search for Stepped Layout and turn it off.
If you want there is also an option to turn off the +/-.
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @MFelix , thank you for resposding but I did what you said but its not helping me. Its still hirarchy mode.
Hi @Sayesd ,
Do you have more than one Product name each Product? How is the result you are achieving? Have you tried using a simple table?
Without data is difficult to give you the correct answer since the modelling and the table columns and measure change the result you may have.
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em Português@MFelix the data that I give is sample data
The result table is showing.
ProductName | 1 - 10 | 11 - 20 | 21 -30 | 31 - 40 |
+A | $12 | $54 | $34 | $21 |
+B | $65 | $34 | $27 | $98 |
+C | $43 | $12 | $98 | $53 |
+D | $87 | $96 | $45 | $97 |
Expected table
ProductName | ProductID | Address | 1 - 10 | 11 - 20 | 21 -30 | 31 - 40 |
A | 12 | 3245 A st | $12 | $54 | $34 | $21 |
B | 32 | 1123 B st | $65 | $34 | $27 | $98 |
C | 43 | 23 E st | $43 | $12 | $98 | $53 |
D | 56 | 54 B st | $87 | $96 | $45 | $97 |
Hi @Sayesd ,
If you click the + button you will opewn the hierarchy has you need in the example below I have turn off stepped layout and +/- buttons the drill can also be done using the buttons highlithed
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsUser | Count |
---|---|
79 | |
74 | |
62 | |
61 | |
45 |
User | Count |
---|---|
108 | |
98 | |
89 | |
82 | |
61 |