Forum Discussion
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 😊
Hi BA_Pete
Thanks for the tip. I’ve done as you say (see below) and I’m thinking that the solution must relate to either or 2nd or 3rd suggestion. Namely, ‘Your fact or dimension table contains a null value’ or ‘Your fact or dimension field has been left as 'Untyped' from Power Query and there are mixed data types e.g. 0 and "0".’
I’ve rechecked the data type of the columns ‘Category Scales’[Index] and [Comorbidities_Present] and they are both set to ‘Whole Number’. Do you have any suggestions on what I should try next?
Super UserHi Anonymous ,
The extra table to be added to your report should be the raw data in your fact table, not just the chart in table format.
In that new table, put the following fields:
'Category Scales'[Index]
'Category Scales'[EN Number]
'ICHOM Patient'[Index or Unique ID field]
'ICHOM Patient'[Comorbidities Present]
yourLegendTable[Index]
(if this last one gives you a relationship error, then create another new table with just yourLegendTable[Index], 'ICHOM Patient'[Index or Unique ID field], and 'ICHOM Patient'[Comorbidities Present] in it).
Now click on the blank axis in your chart and see which exact fact rows are giving you the issue.
Pete