Parent column in group by column selection is unavailable for selection

[samaguire]

As per the title. i.e. I try to set Group By Columns on column 'A', column 'A' isn't listed in the column selection list.

As per SQLBI article, it would be best practice to also include the parent column (https://www.sqlbi.com/articles/understanding-group-by-columns-in-power-bi/)

** Which version are you currently using? ** TE3 v3.7

To Reproduce Power BI Desktop

Expected behavior The parent column is available for selection.

[otykier]

Hi @samaguire I may be misunderstanding, but from the SQLBI article, it looks like the Group-By columns is being assigned on the Customer[City (unique)] column. The warning mentions that we should also include Customer[City] as a Group-By column, not the Customer [City (unique)] column itself?

[samaguire]

Fair point.

I read the line "In order to keep a single demo file, we duplicated the City column into City (unique)" as meaning that normally this would be actioned against the original column, not a duplicated column.

Perhaps I'm getting it wrong myself, and should be creating the duplicate column?

[otykier]

Let's ask @marcosqlbi to clarify :)

But in any case, I don't think that it should ever be necessary to add a column as a group-by column on itself.