Show underlying values

[Anonymous]

Hello,

I'm looking to show the underlying values reported by a measure in a matrix. Is there any way that this can be done? when I right-click, I'm see show as table, but this doesn't take me to the underlying values, it just "zooms in" on the values that are already there. Any thoughts as to how I can do this?

[V-lianl-msft · Accepted solution]

Hi @Anonymous ,

Refer to these:

https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-drillthrough 

https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-cross-report-drill-through 

https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-tooltips 

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak · Accepted solution]

@Anonymous , refer to this article, it is showing steps to do it

https://thinkaboutit.be/2020/02/how-do-i-add-a-drill-through-to-see-records-in-power-bi-desktop/

[Anonymous]

Thank you Both! @amitchandak @V-lianl-msft 

That explains it! Previous reports were built in such a way that that the teams weren't able to see the underlying data so there was no way to verify that the numbers are right and my stakeholders are asking to see it so that they can verify (at least initially). this is great!

[V-lianl-msft · Accepted solution]

Hi @Anonymous ,

Refer to these:

https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-drillthrough 

https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-cross-report-drill-through 

https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-tooltips 

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.