Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello, I am trying to emulate some functionality in an existing Excel file, but can't seem to find the right solution.
Excel allows you to group columns, along with the ability to expand / collapse. This helps reduce the amount of numbers a user has to look at by default, but if they want more detail they can expand the columns.
I know in a matrix visual this is built into the row functionality, but I don't see a way to expand / collapse columns. Any ideas?? Thanks
Solved! Go to Solution.
@kurtsmetana , If you more than one column in col of the matrix, then there is an option to drill down at the column level.
But with one col and multiple fields/values it is not.
Refer:https://docs.microsoft.com/en-us/power-bi/visuals/desktop-matrix-visual
@kurtsmetana , If you more than one column in col of the matrix, then there is an option to drill down at the column level.
But with one col and multiple fields/values it is not.
Refer:https://docs.microsoft.com/en-us/power-bi/visuals/desktop-matrix-visual
Hi @kurtsmetana
I do not see such option in in-build Power BI visuals, maybe you can find something in AppSource https://appsource.microsoft.com/en-us/marketplace/apps?product=power-bi-visuals
User | Count |
---|---|
93 | |
85 | |
78 | |
68 | |
63 |
User | Count |
---|---|
113 | |
99 | |
96 | |
64 | |
58 |