Advocate IEnhance Power BI Desktop Table View with Quick Column Summary Statistics
To enhance the user experience and analytical capabilities within the Power BI Desktop Table View, I propose enhancing the feature that displays quick summary statistics for selected columns. This functionality would be similar to the convenient summary features found in Excel.
Specifically, when a column is selected in the Table View, the following statistics should be displayed at the bottom of the screen, dynamically updating based on any applied filters:
For Numeric Fields: Sum, Average, and Row Count.
For Text Fields: Row Count, Distinct Row Count.
For Date Fields: Row Count, Minimum Date, and Maximum Date.
Enhancing this feature would significantly improve data validation within Power BI Desktop by providing immediate insights into column data, without requiring users to create explicit measures or paste into Excel. It would streamline DAX formula validation.
Pasting in Excel screen shot for an example:
This is what I see in Table view today:
