Forum Discussion
Scatter Plot Clustering created a "Blank" category
I am working through the first section of module 4 of the Coursera Data Analysis and Visualization with Power BI course. one of the assignments is to create 4 clusters for the scatterplot (see left image). I wanted to expand the work to create a bar chart for these clusters as well. When i created the bar chart a "blank" category was shown. The sum of the 5 categories in the bar chart is equal to the total sales value for the data set. I checked the data tables and there are no "blank" city names.
Any thoughts on what this bank category was created?
Hi Anonymous ,
This is because there are values in the Fact table that are not in the Dim table, and the engine automatically creates a Blank and categorizes the values that don't correspond.
By checking, 'Reseller'[ResellerKey] is missing the value -1, This would invalidate the relationship.
Measure = CALCULATE(SUM('Sales'[Sales Amount]),'Sales'[ResellerKey]=-1)Make sure that the 1 side of the relationship contains all the values of the multi-side and does not contain blank values.
Best Regards,
Gao
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
6 Replies
- Ashish_Mathur
Super User
Hi,
Share the download link of the PBI file.
- Ashish_Mathur
There is no bar chart in that file. Create the bar chart and share the download link again.
https://1drv.ms/u/c/7e3053aadba7a24a/EVANdkz-9KJJuXHqhdvDnXAB2NgHR0XcPrsdcCithelwfw?e=73Jj0G
sorry. i though that you wanted the original link.
Hi Anonymous ,
This is because there are values in the Fact table that are not in the Dim table, and the engine automatically creates a Blank and categorizes the values that don't correspond.
By checking, 'Reseller'[ResellerKey] is missing the value -1, This would invalidate the relationship.
Measure = CALCULATE(SUM('Sales'[Sales Amount]),'Sales'[ResellerKey]=-1)Make sure that the 1 side of the relationship contains all the values of the multi-side and does not contain blank values.
Best Regards,
Gao
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
