Forum Discussion
Power BI Service – Column Summary & Row Count Feature
- 8 months ago
Short answer: no, Power BI Service does not have a built-in feature that automatically shows column-level summaries (min, max, avg, distinct count) and total row count for whatever data the user is currently viewing, like ThoughtSpot does.
But not in the way you’re probably expecting, you can calculate column summaries (min, max, avg, distinct count, row count) in a Fabric notebook using Spark or SQL, but that happens outside the report experience. It’s more suitable for data profiling, validation, or pre-calculation, not for showing live summaries based on what a user is currently filtering in a Power BI report.
Also, You can compute min, max, avg, distinct count, and row counts in Power Query, but it all happens at refresh time. Once the data is loaded, those results are static and cannot respond to slicers, filters, or what the user is currently viewing in the report.
Thank you v-hjannapu!
This is helpful for now, will reach out in case of any additional assistance is required.