Missing Categorical Variable Values

[JessQA]

Hi Everyone,

Below is a visualization of my issue:

Does anyone have a suggestion on how I can fix this issue in BI?

Thank you!

[v-qiuyu-msft · Accepted solution]

Hi @JessQA,

From the images, you created the PivotChart in Excel instead of Power BI desktop, right?

Based on my research, the chart horizontal axis will display labels based on [Blood Type] column values. If you want to display other values which are not in this column, you need to create another column to contains complete blood type.

If you have any question about PivotChart, please post a thread in Power Pivot forum to get dedicated support.

Best Regards,
Qiuyun Yu

[alanhodgson]

Hey @JessQA,

Thanks for stopping by, have you tried the "Show items with no data" option. See the screenshot below:

Hope this helps,

Alan