Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Issue:
When a column title includes the name of a Data Category label (Address, City, Continent, Place etc.) the default summarization used on the field becomes an average and there is no way to override the behaviour.
Steps to reproduce:
Sample m query below:
let Source = Table.FromRows( Json.Document(Binary.Decompress(Binary.FromText( "i45WMlTSUTI2ARIWQGxuphSrE61kBGSaQoUswCIgBWZAbAkSsQQLgRSYA7EBWDg2FgA=" , BinaryEncoding.Base64), Compression.Deflate ) ) , let _t = ((Int64.Type) meta [Serialized.Text = true]) in type table [ Placements = _t , #"Number Placed" = _t , #"Continental Appointments" = _t , Addressees = _t ] ) in Source
Expected Behaviour
The default summarization behaviour set on a field (under the Modelling header) should override any 'internal' default summarization applied by Power BI.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.