Forum Discussion

JessQA's avatar
JessQA
Frequent Visitor
9 years ago
Solved

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!  
Need Help
  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    9 years ago

    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

     

     

v-qiuyu-msft's avatar
v-qiuyu-msft
Community Support
9 years ago

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