Forum Discussion
kishordute
1 year agoRegular Visitor
Columns summarization disabled due to Tabluar editor
Need help , have used tabluar editor long back on one of by workbook and it disabled aggrigation of columns. I had created a custom table. please assist
- 1 year ago
Hi kishordute ,
1.Since aggregation is only enabled for numeric fields, can you check the the data type is numeric?
2. If this alo doesnt work, try this in your editor-
foreach (var col in Model.AllColumns)
{
if (!col.IsHidden && col.DataType == DataType.Int64)
{
col.SummarizeBy = AggregateFunction.Sum;
}
}
3. Else you can duplicate the column and give it a different name and make sure its numeric and then perform aggregation.
Hope this helps!
If the response has addressed your query, please Accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank You
kishordute
1 year agoRegular Visitor
It's more like have made some setting in tabluar editor addin of Power BI due to which my database columns summarization option is disabled.