Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It 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 |
---|---|
98 | |
90 | |
77 | |
71 | |
64 |
User | Count |
---|---|
114 | |
97 | |
95 | |
68 | |
65 |