Removing NULL from the Group

[smibrahim]

Hello All, Thank you for Jumping in to assist on this.

We have a bar chart generated with X and Y axis.

The running numbers for Y axis is generated by using Groupby. It means, we have values from 1 till 42 and the Grouping Bin value is set as "5" and so the Y axis runs as 0, 10, 15, 20, 25.......as dynamic data.

The requirement here is that there are some Y axis values such as 20, 35 where the corresponding X axis data is not present and it appears as blank. In this case we dont want 20 and 35 to be displayed in the Y axis and the series should be 0,10,15,25,30,40.....

We tried with Advanced Filter as "Ignore blank" and all options. But couldn't restrict it.

Do we have an inbuit feature or should we do a workaround?

Thank you.

[v-yulgu-msft · Accepted solution]

Hi @smibrahim,

Please change the Y-axis type from "Continuous" to "Categorical".

Best regards,

Yuliana Gu

[v-yulgu-msft · Accepted solution]

Hi @smibrahim,

Please change the Y-axis type from "Continuous" to "Categorical".

Best regards,

Yuliana Gu

[smibrahim · Accepted solution]

Hello Yuliana,

Hurray!!! It helped. Thank you very much 🙂

Best Regards,

Siraj