Pivot Table Data Not Grouping after Adding Source Data to Data Model

[radonwilson]

To use the Distinct Count option in Pivot Table, I have added the source table to Data Model. Although, I got the distinct count but later I was not able to group my Data in the Pivot Table. I am getting the error "Cannot group that selection".

How to fix it?

 

[Kerryx]

Without seeing source data just taking a stab in the dark that possible something may be in different format or column of data may have an error

 

[radonwilson]

Without seeing source data just taking a stab in the dark that possible something may be in different format or column of data may have an error

I am facing the same issue as addressed on this webpage

Problem Grouping Pivot Table Items – Contextures Blog

contexturesblog.com