Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
I have a table that looks like this.
column1 column2
NE A
NE B
NE C
SE D
NW E
NW F
I want to hide the duplicate values in column1 so my table looks like this
column1 column2
NE A
B
C
SE D
NW E
F
Is this possible?
Thanks,
Tom
hi @tomgramling
You could use matrix visual as below:
Note: Disable Stepped layout in Format-> Row headers
Regards,
Lin
I need it to remain as a table for some other reasons. A matrix won't work in this instance.
hi @tomgramling
To my knowledge, it could not achieve in table visual in power bi for now,.
Regards,
Lin
Hi @tomgramling ,
You can use the matrix visual to achieve something similar.
https://docs.microsoft.com/en-us/power-bi/visuals/desktop-matrix-visual
User | Count |
---|---|
87 | |
72 | |
68 | |
64 | |
54 |
User | Count |
---|---|
98 | |
89 | |
74 | |
67 | |
62 |