How can I show underlying data of any measure like tableau

[naftycs]

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

🙂

[amitchandak]

@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