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 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
Solved! Go to 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
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
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 |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |