Stop a "Zero" value displaying as (blank)

Hi Pete,

I agree that it’s a relationship mismatch. There is another relationship between the dimension and fact table and that was causing the problem. The calculation on [Comorbities_Present] can only be a round number because it only counts the individual values in a column containing semi-colon separated values e.g. ‘2;5;6’. I have made a new dimension table specifically for translating numbers to text. Now ‘Zero’ is shown:

And so that I don’t need to keep repeating HEX codes, I will make a dimension table for that and link it to the category_scales and the new table.

Thanks for your help. I’m working alone here, so it’s been nice to bounce ideas off another person, rather than just speaking into the ether 😊