Nulls in Pivot Table and Bart Chart

[0li5a3a]

Hi all,

Could someone adivce me how to DON'T display the  " -" into the Pivot Table and Bart Chart?

I want to mention that I still want to display the Months with no data in it but I don't want to see this " - " in the legend in the Bart Chart and in Type in the Pivot Table.

Please find the attached files where I have created a scenario.

Kind regards,

C

[sergio0592]

Have you already tried to check "Supress Zero value" in presentation Tab?

[0li5a3a]

yes, but if you want to select year 2016,2017 all the months with no data would go. I want o displya even the months with no data in....

[sergio0592]

In your dimension, as a calculated dimension try with :

if(len(Type)>1,Type)

[0li5a3a]

stil the same, I am afraid

[balabhaskarqlik]

Include null values - All null values are displayed as gaps or dashes (-).

Uncheck the Populate Missing cells.

[0li5a3a]

I have added a test scenario and now you can  play with, anyway your solution doesn't work in my case.

[0li5a3a · Accepted solution]

Hi all,

I come with the solution, please use it in future if you need to exclude the nulls from legends.

Regards, C