Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
By the time I was done looking for an answer, I could have been halfway done, but here goes... Groups and grouping is useless to me in PBI (because I do these things in the database), but I got this report from this guy where he did all this tedious, manual grouping using the incredibly powerful "edit groups" utility of PBI. Now, I need to extract this grouping data from the report for my db work.
I tried to create a slicer for the "groupings", whereupon I could just download the grouped items from a simple table. But when I drop the group into a slicer, it just displays all ungrouped items, not the groups. I tried it with a "Heirarchy Slicer", but the result was the same.
There must be a way to perform this simple task. Any advice would be greatly appreciated.
Solved! Go to Solution.
@v-yulgu-msft thanks for the reply. I did get it working in a matrix afterall. Once you publish the report to 'My Workspace', you can then download the data to a spreadsheet or other format. It's funny how the matrix shrinks into a single colum in the download, but that was actually better. Then, I could parse to my heart's content.
Hi @joglidden2 ,
I tried to create a slicer for the "groupings", whereupon I could just download the grouped items from a simple table. But when I drop the group into a slicer, it just displays all ungrouped items, not the groups. I tried it with a "Heirarchy Slicer", but the result was the same.
I cannot imagine the result as mentioned ” it just displays all ungrouped items, not the groups”. Please describe your problem with sample data and screenshot of current result and desired result.
Best regards,
Yuliana Gu
@v-yulgu-msft thanks for the reply. I did get it working in a matrix afterall. Once you publish the report to 'My Workspace', you can then download the data to a spreadsheet or other format. It's funny how the matrix shrinks into a single colum in the download, but that was actually better. Then, I could parse to my heart's content.
@v-yulgu-msft thanks for the reply. I did get it working in a matrix afterall. Once you publish the report to 'My Workspace', you can then download the data to a spreadsheet or other format. It's funny how the matrix shrinks into a single colum in the download, but that was actually better. Then, I could parse to my heart's content.
I also tried this with a matrix, which at least displays the group names in cols, but nothing downloadable. A table would be better.
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |