Forum Discussion
Missing labels on Pie Chart
I want to create a pie chart visual on PowerBi desktop. Have added the category in 'Legends' and want to see the segregation as per 'profit' of my data. When I added the 'category' in 'Legends', I noticed that there were different categories appearing, but as soon as I added the 'Profit' to the 'Values' section, the categories disappeared shows as 'Blank'.
I have checked my data model and all the tables are connected. Can someone help me on this?
Hi, Ajay_Halepaty
Based on your description, can you be sure that your problem is the same as what arvindsingh802 described. If the problem is not the same, in my test, all the pie chart information is displayed properly, this is my test data.
Output:
You can try the following to solve your problem:
1. Check Data Type and Aggregation: Ensure that the 'Profit' field you are using in the 'Values' section is of a numeric data type and is being aggregated correctly (e.g., Sum, Average). Sometimes, if the data type or aggregation is not set correctly, it can cause unexpected behavior in how the categories are displayed.
2. Review Category Field: Double-check the field you are using in the 'Legends' section. Ensure that it does not contain any blank or null values. Power BI might interpret these as actual categories, leading to the 'Blank' labels you are seeing. You can use Power Query Editor to clean your data and remove or replace any blank values.
3. Visualization Settings: Explore the visualization settings for your pie chart. Sometimes, specific settings or filters applied to the visualization can impact how data is displayed. Ensure that there are no filters inadvertently hiding your categories.
Best Regards,
Yang
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!How to get your questions answered quickly -- How to provide sample data in the Power BI Forum
2 Replies
Hi, Ajay_Halepaty
Based on your description, can you be sure that your problem is the same as what arvindsingh802 described. If the problem is not the same, in my test, all the pie chart information is displayed properly, this is my test data.
Output:
You can try the following to solve your problem:
1. Check Data Type and Aggregation: Ensure that the 'Profit' field you are using in the 'Values' section is of a numeric data type and is being aggregated correctly (e.g., Sum, Average). Sometimes, if the data type or aggregation is not set correctly, it can cause unexpected behavior in how the categories are displayed.
2. Review Category Field: Double-check the field you are using in the 'Legends' section. Ensure that it does not contain any blank or null values. Power BI might interpret these as actual categories, leading to the 'Blank' labels you are seeing. You can use Power Query Editor to clean your data and remove or replace any blank values.
3. Visualization Settings: Explore the visualization settings for your pie chart. Sometimes, specific settings or filters applied to the visualization can impact how data is displayed. Ensure that there are no filters inadvertently hiding your categories.
Best Regards,
Yang
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!How to get your questions answered quickly -- How to provide sample data in the Power BI Forum
Can you share sample PBIX or screenshot of same
Also did you gone through https://community.fabric.microsoft.com/t5/Desktop/Missing-category-label-on-pie-chart/m-p/208793 if this is related to your issue
