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.
Hi all,
I have some data and created a table:
Company | Bundle | Year |
XYZ CORP | Bronze | 2021 |
ABC CORP | Silver | 2019 |
GHI CORP | Gold | 2018 |
LMN CORP | Gold | 2019 |
XYZ CORP | Silver | 2019 |
XYZ CORP | Silver | 2020 |
I would like to display the table so that is shows up like this (without repeating values in column 1):
Company | Bundle | Year |
XXZ Corp | Bronze | 2021 |
Silver | 2019 | |
Silver | 2020 | |
ABC CORP | Silver | 2019 |
GHI CORP | Gold | 2018 |
LMN CORP | Gold | 2019 |
Any adivise would be apprecitated.
Thanks.
Solved! Go to Solution.
Hi, @PowerBI87
Based on your description, you may create a matrix visual, go to 'Visualization' ribbon, click 'Format'=>'Subtotals', set 'Row subtotals' off, click 'Row headers', set 'Stepped layout' off.
Result:
Best Regards
Allan
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, @PowerBI87
Based on your description, you may create a matrix visual, go to 'Visualization' ribbon, click 'Format'=>'Subtotals', set 'Row subtotals' off, click 'Row headers', set 'Stepped layout' off.
Result:
Best Regards
Allan
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you very much!
User | Count |
---|---|
77 | |
77 | |
68 | |
67 | |
49 |
User | Count |
---|---|
108 | |
105 | |
93 | |
83 | |
64 |