Forum Discussion
Whole Number - Sematic Model
Converting a True/False column to a whole number in a dataflow and then editing it in the semantic model to summarize by 'Sum' isnt showing the sum symbol next to the field when editing it in PowerBi services online.
Usually it would give you the option to sum, count etc.
Does anyone know why this is not allowing me to do this ?
Hi CEllis ,
Thanks for confirming.
Yes, there can be differences between working in Power BI Service and Desktop, depending on how the semantic model is configured.
In Power BI Desktop, you have full control over the model, and numeric columns typically show the sigma icon and aggregation options as expected. In Power BI Service, this behavior can differ if the dataset is using a live connection, Direct Lake mode, or a shared semantic model, where some modeling properties are not fully exposed.
Since the behavior remains unchanged after refresh, I would suggest downloading the semantic model into Power BI Desktop (if that option is available), verifying the column data type and default summarization there, and then republishing.
Please reach out for further assistance.
Thank you.
8 Replies
Hi CEllis ,
Thanks for reaching out to Microsoft Fabric Community.I tried to reproduce this by converting a True/False column to Whole Number in a dataflow and using it in a table visual. In my test, the column shows the sigma icon and aggregation options such as Sum and Count are available.
Since the sigma icon is not visible in your case, it suggests that the column is still being treated as a non-aggregatable or categorical field in the semantic model, even though the data type is Whole Number.
This can happen if the metadata change from the dataflow has not fully propagated, or if the column is being treated as a key or attribute.
I would recommend refreshing the semantic model and confirming the column’s data type and default summarization in the model.
Hope this helps. Please reach out for further assistance.
Thank you.I've tried the soloution and it stays the same.
Would it make a differnce between editing it online as apose to editing it using the desktop version.
Hi CEllis ,
Thanks for confirming.
Yes, there can be differences between working in Power BI Service and Desktop, depending on how the semantic model is configured.
In Power BI Desktop, you have full control over the model, and numeric columns typically show the sigma icon and aggregation options as expected. In Power BI Service, this behavior can differ if the dataset is using a live connection, Direct Lake mode, or a shared semantic model, where some modeling properties are not fully exposed.
Since the behavior remains unchanged after refresh, I would suggest downloading the semantic model into Power BI Desktop (if that option is available), verifying the column data type and default summarization there, and then republishing.
Please reach out for further assistance.
Thank you.
Hi CEllis ,
We wanted to kindly follow up regarding your query. If you need any further assistance, please reach out.
Thank you.
