Pivot Grid feature does not work with hidden fields

[data-goblin]

Hi there,

Noticed today a possible issue with the Pivot Grid feature & hidden fields (TE Enterprise 3.1.7). Apologies if this is the intended behavior:

If a table or column is hidden, the values will not load / show in the pivot grid. This can be observed when adding a field to the pivot grid (i.e. 'Date'[Year]), hiding it & saving changes, then refreshing the pivot grid. Unhiding the field causes the values to re-appear. This is observed with both columns & measures. For measures, hiding the "home table" containing the measure does not have an impact, however.

---

See attached images:

Unhidden table; Unhidden Column ✔

Unhidden table; Hidden column ❌

Hidden table; Unhidden column ❌

---

Unhidden table; Unhidden measure ✔

Unhidden Table; Hidden Measure ❌

Hidden table; Unhidden Measure ✔

[otykier]

We'll look into it - thanks for reporting.

[edhans]

Yup. Came here to report the same thing. Unhiding the field fixes it. This is in 3.2.2

[mlonsk]

Getting slightly different behaviour for measures, as instead of not being shown the hidden measure is shown as having "Error":

If the measure is turned to visible the Pivot grid works again