Row level data

[karkar]

Hello,

I have a report(a graph) generated in Power Bi .

Example : 78% are Pass and 22% are Fail.

How can i see the underlying data at the row level? I want to see who are all included under the Pass category and fail respectively.

When I try to export data , there are two options: Summarized Data and Underlying data.

By default the underlying data is greyed.

Thanks

[v-qiuyu-msft · Accepted solution]

Hi @karkar,

In Power BI service, when we export data from a visual, if the visualization does have an aggregate, the Underlying Data option will be available. Otherwise it's greyed out. For more information, see: Export data from Power BI visualizations.

In your scenario, which kind of visual did you use? Did you calculate the percentage from a measure or a calculated column? Would you please show the screenshot about table data used in the visual like below?

Besides, you can use Analyze in Excel feature to analyze dataset data. See: Analyze in Excel.

If the visual is bar chart (or other supported chart) and doesn't contain any measure, you can use See Records to see it's underlying row data: See: Use See Data and See Records in Power BI Desktop.

Best Regards,
QiuyunYu