Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello:
I hope you are doing great. Thanks for helping me to learn Power BI. I have a question. I want to show the underlying data of measure in a table as a pivot table. How can I show that in Power BI?
Year | Region | Id | Team |
2021 | East | 1001 | A |
2022 | North | 1002 | B |
2020 | South | 1003 | C |
2021 | East | 1004 | A |
2022 | North | 1005 | B |
2020 | South | 1006 | C |
2021 | East | 1007 | A |
2022 | North | 1008 | B |
2020 | South | 1009 | C |
2021 | East | 1010 | A |
2022 | North | 1011 | B |
2020 | South | 1012 | C |
2021 | East | 1013 | A |
2022 | North | 1014 | B |
2020 | South | 1015 | C |
2021 | East | 1016 | A |
2022 | North | 1017 | B |
2020 | South | 1018 | C |
2020 | East | 1019 | A |
Output:
Count of IdColumn Labels Row LabelsEastNorthSouthGrand Total20201 6720216 62022 6 6Grand Total76619
A | 1 | 1 | ||
C | 6 | 6 | ||
A | 6 | 6 | ||
B | 6 | 6 |
I want to see underlying data like following:
YearRegionIdTeam
2020 | South | 1018 | C |
2020 | South | 1015 | C |
2020 | South | 1003 | C |
2020 | South | 1012 | C |
2020 | South | 1009 | C |
2020 | South | 1006 | C |
Appreciate your help.
Thanks
🙂
@naftycs , when exporting you have the option to get underlying data. Or you can create a page and enable drill through
https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-drillthrough
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
117 | |
104 | |
77 | |
73 | |
52 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |