Multi-Column Value Chart not showing values

_DanielB_

Hi

I've created 2 case statements to look at current and previous month using an integer rank column created in the ETL based on the Year and Month (202505 = 1 and 202504 =2)

When I look at the output data set, these numbers are formatted as an integer as expected and when I create case statements that reference these integers they work when I create a table i.e.

CASE WHEN Rank = 1 Then Count (ID) END

CASE WHEN Rank = 2 Then Count (ID) END

Next to May 2025 I can see the correct figure with blank in April 2025 and vice versa for the second statement

However, when I use the exact same Beast Modes for the Gauge and Comparison Values I get a blank card

The idea behind this is that when the new months come in, they will be 1 and the previous month will become 2 as time goes on for the month on month comparison

What am I doing wrong here?

Many many thanks

Dan

ArborRose

The issue of blanks is a common on that normally comes from filtering or aggregate issues. I would try aggregating with something like

SUM(CASE WHEN Rank = 1 THEN 1 ELSE 0 END)