The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Ive dug through all the documentation and forum posts but can't seem to find a solution. Power BI will not recognize a column in my data as numeric which is preventing me from leveraging the aggregation features.
Link to what I am talking about: https://learn.microsoft.com/en-us/power-bi/create-reports/service-aggregates
I have done the following so far:
I am not seeing the Numeric Field Sigma icon anywhere too. It doesnt show up next to the column on Report View, Table View, or Model View. When I drag my "Value" column to a "Values" field in a visual, it does nothing. Below is a screenshot of what I see. Why is the Sigma symbol missing? Is this a setting issue?
Solved! Go to Solution.
@gordoncappo , check this https://community.fabric.microsoft.com/t5/Desktop/Missing-Sum-Icon-in-the-table/td-p/1881045
Proud to be a Super User! | |
Hello @gordoncappo ,
then there's a value im your field that is not a number that is preventing you from converting the column to an aggregate.
Proud to be a Super User! | |
Hi @Idrissshatila thank you for your response.
I don't know how that would be possible because there is no data error in power query and I can write a simple SUM formula on the column with no issue. Screenshot of the the column quality in power query.
if you can write a sum measure then what's the problem, you could write a measure to aggregate.
Proud to be a Super User! | |
I am wondering why it will not show the Numeric Field Sigma icon? Is there a setting I need to adjust?
@gordoncappo , check this https://community.fabric.microsoft.com/t5/Desktop/Missing-Sum-Icon-in-the-table/td-p/1881045
Proud to be a Super User! | |
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
97 | |
94 | |
88 | |
71 | |
65 |
User | Count |
---|---|
241 | |
124 | |
120 | |
81 | |
79 |