Error on a slice

1X_fb23f9e192933bc6714d443cc5bf3c1dabf27f0d.png

Hello
how come I get this error on a slice?

0 9 340
  • UX
9 REPLIES 9

Steve
Platinum 4
Platinum 4

Likely you created a slice that includes the rowโ€™s ID column but hides it from the userโ€™s view, and the ID column has no initial value, or an initial value that is blank.

Make sure your ID column has an Initial value expression and that it will never produce a blank value.

yes, I have an ID column with numbers in progress.
I add a first slice and everything works.
when I add a second slice on the first slice everything works instead in the second one gives me this error

Are both slices on the same table?

Do both slices include the same columns?

What is the expression for generating the ID column value?

I am forced to create new views without slices
referring to the entire sheet

They are made of the same table
In the ID column there are static numbers I entered as an example (1.2.3.4 etc.)
Claims do not include the same columns except the ID value

The error in the screenshot suggests the ID column for that row has no value. If youโ€™re entering the ID values manually, that error can only mean you didnโ€™t enter an ID value.

unfortunately I did not understand

Please provide a screenshot that shows both the error and the ID column at the same time.

Top Labels in this Space