% Change - Prior Month Blank

[Dimitry Rogov]

Hello,

I am trying to show Month over Month variation with percentage and value. However, when using the "% Change" format, for September, I am shown blank values and cannot remove them (Please see images). What is the best way to remove September from the data or perhaps just show the actual values with the % change, etc.?

[Fredrik Rosell]

Hello Dimitry,

Have you tried the "Hide Empty Values" button that is visible in the screenshot? It that works for your use case, that's a very easy way to achieve what you described. When you click that button, it creates a Show/Hide Items Rule for hiding empty values.