Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 months ago
Solved

Power BI Service – Column Summary & Row Count Feature

Hi Team, I wanted to check if Power BI Service provides a feature to display column-level summaries (for example, min, max, average, distinct count) and the total row/record count for the report...
  • cengizhanarslan's avatar
    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.