SSAS Tabular - Grouping in Excel - grayed out for Tabular?

Question

I have a Tabular data model and I'm returning a measure that counts employees (each row is an employee) and then a calculated column in the model that gets SeniorityInMonths.

So if an employee was hired exactly 1 year ago, they would have 12 in this column.

I want to group these into bins, but the Group option is grayed out.

Is there anyway around this?

Answer 1

I want to group these into bins, but the Group option is grayed out.

Please elaborate, its unclear. May be screen shot will help.

---

If this post answers your query, please click "Mark As Answer" or "Vote as Helpful".

Answer 2

I want to group these into bins, but the Group option is grayed out.

Please elaborate, its unclear. May be screen shot will help.

---

If this post answers your query, please click "Mark As Answer" or "Vote as Helpful".

Note that Group and Ungroup are grayed out.

I can select one or many rows, but it won't let me group them.

I verified they are whole numbers (not a mix of numbers and text).

Not clear as to why I can't use the group feature here.

Answer 3

If you attempt to group a pivot table, but find that the Group... option is greyed out, or that a window pops up, saying "Cannot Group That Selection", this is usually because the data column in the original data sheet contains one or more non-numeric values (or non-date values), or errors.

In order to fix this, you will need to return to your original data sheet and amend the non-numeric values (or delete the rows containing the non-numeric values).

Once you have done this, right click on the pivot table and select Refresh. This will update the values in the pivot table, and you should now be able to group the selected row or column values.

Try setting your calculated column data type as Whole Number.

Source: http://www.excelfunctions.net/group-pivot-table.html

---

If this post answers your query, please click "Mark As Answer" or "Vote as Helpful".

Answer 4

If you attempt to group a pivot table, but find that the Group... option is greyed out, or that a window pops up, saying "Cannot Group That Selection", this is usually because the data column in the original data sheet contains one or more non-numeric values (or non-date values), or errors.

In order to fix this, you will need to return to your original data sheet and amend the non-numeric values (or delete the rows containing the non-numeric values).

Once you have done this, right click on the pivot table and select Refresh. This will update the values in the pivot table, and you should now be able to group the selected row or column values.

Try setting your calculated column data type as Whole Number.

Source: http://www.excelfunctions.net/group-pivot-table.html

---

If this post answers your query, please click "Mark As Answer" or "Vote as Helpful".

Sadly I already did those things, no change.

The column has no blanks.

The column is all whole numbers.

Properties are set to Date Format = Whole Number and Data Type = Whole Number

There is no error message because I can't click on the "Group" command as it is grayed out..

Answer 5

It looks like grouping is not supported in tabular model. Check this link:

https://social.msdn.microsoft.com/Forums/en-US/339962d8-1b48-4fd2-b144-7fdd37f6d76d/sql-tabular-model-groupungroup-greyed-out-in-excel

---

If this post answers your query, please click "Mark As Answer" or "Vote as Helpful".

Answer 6

You can't use Excel to do this, but you can build this sort of functionality into your model using techniques list this

http://www.daxpatterns.com/dynamic-segmentation/

---

http://darren.gosbell.com - please mark correct answers