Forum Discussion
Customer Segmentation doesn't show up
Hi lamia89 ,
From the results of the pie chart display you provided, you placed both [Customer Segment] and [total_spending] into Value
If there are no fields placed in Legend, then [Customer Segment] and [total_spending] will not be grouped together and will all show one value
You can place [Customer Segment] in the Legend and [total_spending] in the Value so that [total_spending] will be grouped by [Customer Segment].
If the above method does not meet your expectations, Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data. We can better understand the problem and help you.
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 Replies
Hi lamia89 ,
From the results of the pie chart display you provided, you placed both [Customer Segment] and [total_spending] into Value
If there are no fields placed in Legend, then [Customer Segment] and [total_spending] will not be grouped together and will all show one value
You can place [Customer Segment] in the Legend and [total_spending] in the Value so that [total_spending] will be grouped by [Customer Segment].
If the above method does not meet your expectations, Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data. We can better understand the problem and help you.
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi lamia89 ,
I created some data:
Are you referring to the number of Customer Segmentation displayed in the pie visual.
You might consider placing [Customer Segmentation] in the Legend and Values of the pie visual.
If the above results do not meet your expectations, can you express the expected results in the form of a picture, we can help you better.
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
I used this code to create new column for customer segmentation
Customer Segment =IF ('Cleaned Sales Data'[SALES] <= 9100, "Low Value",IF ('Cleaned Sales Data'[Total Sales] <= 330000, "Mid Value",IF ('Cleaned Sales Data'[Total Sales] <= 900000, "High Value")))but it shows only low and mid value but there's is high values , in python visualization the correct one shows the correct data while the one with power bi nor correct
