Hello,
I have a power pivot model and I have created a pivot table on it, on Excel.
I realize that I cannot display easily the items without data, when I filter.
The option is greyed out in the pivot filed settings.
After some research I understand I need to manage it in powerpivot itself inside measures I could create.
But it is beyond my current power pivot level
I don't manage to create a measure that could display data with empty values, and only depending on the filters applied on slicers.
See attached file, I have created a little example of the problem and the expected result
Hope someone will help
Thank you in advance.
I have a power pivot model and I have created a pivot table on it, on Excel.
I realize that I cannot display easily the items without data, when I filter.
The option is greyed out in the pivot filed settings.
After some research I understand I need to manage it in powerpivot itself inside measures I could create.
But it is beyond my current power pivot level
I don't manage to create a measure that could display data with empty values, and only depending on the filters applied on slicers.
See attached file, I have created a little example of the problem and the expected result
Hope someone will help
Thank you in advance.