Forum Discussion
Missing Categorical Variable Values
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!
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
2 Replies
Hey JessQA,
Thanks for stopping by, have you tried the "Show items with no data" option. See the screenshot below:
Hope this helps,
Alan
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
