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.
There are 3 data in the table. but in matrix visual There is 1 data. how to show all data
Solved! Go to Solution.
@komkit , for that you have to index the column and bring it visual as not summarized
Power Query- Index Column: https://youtu.be/NS4esnCDqVw
Hi @komkit .
Unfortunately, there is no way to display duplicates line by line.
Additionally, by adding an index column, the number of rows can be opened based on their repetitions.
Please see the attached link.
https://stackoverflow.com/questions/69539709/keep-duplicate-data-in-matrix-visual-power-bi
If you still need to see every repetition visualy, you could use the connection between the category and its index and display either as an additional hierarchy or on its own.
Did I answer your question? Mark my post as a solution! Appreciate your Kudos 🙂
Hi @komkit .
Unfortunately, there is no way to display duplicates line by line.
Additionally, by adding an index column, the number of rows can be opened based on their repetitions.
Please see the attached link.
https://stackoverflow.com/questions/69539709/keep-duplicate-data-in-matrix-visual-power-bi
If you still need to see every repetition visualy, you could use the connection between the category and its index and display either as an additional hierarchy or on its own.
Did I answer your question? Mark my post as a solution! Appreciate your Kudos 🙂
@komkit , for that you have to index the column and bring it visual as not summarized
Power Query- Index Column: https://youtu.be/NS4esnCDqVw
User | Count |
---|---|
77 | |
74 | |
62 | |
61 | |
45 |
User | Count |
---|---|
108 | |
102 | |
93 | |
83 | |
64 |