Multiple columns with different data, different data grouping issue

wellsayd — Wed, 28 Feb 2018 17:34:11 GMT

Order Date	Region	Rep	Item	Units	 Unit Cost 	 Total Sales 	Returned
1/1/17	Illinois	Maria	A	55	 $1.54 	         $84.44 	TRUE
1/5/17	Massachusetts	Jane	C	96	 $3.49 	         $334.74 	FALSE
1/8/17	New Mexico	Bill	A	88	 $3.53 	         $311.06 	TRUE
1/12/17	Vermont	        Steve	D	38		         $183.46 	TRUE
1/15/17	Virginia	Nadine	E	8	 $3.06 	         $24.49 	TRUE
1/17/17	Maryland	Maria	F	64	 $3.51 	         $224.34 	TRUE
1/18/17	California	Jane	E	5	 $2.39 	         $11.95 	FALSE
1/19/17	Pennsylvania	Bill		29	 $0.98 	         $28.41 	FALSE
1/23/17	Arizona	        Bill	A	11	 $4.42 	         $48.66 	FALSE
1/27/17	Colorado	Steve	D	74	 $0.75 	         $55.62 	TRUE

In my previous post, I was dealing with 1 column and how the similar values in that 1 column will be grouped.

With multiple columns, different data and how they will be grouped differently (default behavior) ... I am not sure how to describe this in the capabilities file.

Thank you for the help!

Re: Multiple columns with different data, different data grouping issue

v-chuncz-msft — Fri, 02 Mar 2018 04:59:59 GMT

@wellsayd,

As mentioned here, dataset owners have the option to set the default summarization for each field. If you are a dataset owner, change the default summarization in the Modeling tab of Power BI Desktop.

topic Multiple columns with different data, different data grouping issue in Developer

Multiple columns with different data, different data grouping issue

Re: Multiple columns with different data, different data grouping issue