Possible to drill-down to transaction level via "Show Data"?

[Trudgeon]

Hello,

I'm wondering if it's possible to allow my users to see the transactional detail when selecting "Show Data" on a visualization

Currently, I have a bar chart of sales by region.  When I select "Show Data" it only shows the sales data summarized by regions...3 lines of data.  Is there any way to drill-down further?  Ocassionally, a transaction might come through with an "unknown" region and I would love for my users to be able to drill-down to the transaction level, retrieve the invoice number and make the correction on their own.  I'd rather not have to spend my time chasing down anomalies in their data.

Any suggestions would be appreciated!

-Chad

[v-cherch-msft · Accepted solution]

Hi @Trudgeon

It seems you need to add hierarchy for your data. Then you can drill-down the data via 'Show data' as below picture.

Regards,

Cherie

[Trudgeon]

Thanks, @v-cherch-msft.  That's exactly what I needed!