If you don't want to use the default aggregation in a field (usually SUM), you can change it a visual by right-clicking on the field and choosing a different aggregation. Or, to change the default, you can choose a different default aggregation in Table view. The Table view list of options, however, is missing three options that are available to the visual: Standard deviation, variance and - most importantly, median.
I know you could do all this with measures in DAX, and probably shouldn't be using implicit measures and default aggregations - but I was running an introductory training course, and we haven't got that far yet!
Could you please add the missing options to the table view, so that the two lists match?
1 Comment
- fbcideas_migusrNew MemberStatus added:New
Recent ideas
Expose Power Query as a Standalone Runtime and Command-Line Interface (CLI)
Summary Power Query has evolved into one of Microsoft's most powerful data transformation technologies and is now used across Excel, Power BI, Fabric, Dataflows, Power Platform, and other products. ...juansgr_3 minutes agoNew MemberNew1View0likes0CommentsExpose User Prompt and Agent Response Logs for Fabric Data Agents
Idea: As an engineer responsible for managing and improving Microsoft Fabric Data Agents, I currently have no way to view how users are interacting with the agents I’ve built. While it’s likely that...JoshuaPitzer1 hour agoAdvocate INew1.2KViews26likes2CommentsImprove relationship visualisation in Model View for large semantic models.
When working with complex models containing many fact and dimension tables, relationship lines frequently cross and overlap, making lineage difficult to follow. A useful enhancement would be to allo...jcheeseaos1 hour agoNew MemberNew3Views0likes0CommentsEnable Export and Programmatic Access to Copilot Narrative Text
Copilot Narratives provide valuable AI-generated insights directly within Power BI reports. However, there is currently no straightforward way to export, copy, or programmatically retrieve the exact ...Mario_A_S_13 hours agoNew MemberNew22Views3likes0Comments