Forum Discussion

lamia89's avatar
lamia89
Regular Visitor
2 years ago
Solved

Customer Segmentation doesn't show up

Customer Segmentation = IF (     'Cleaned Sales Data'[Total Sales] <= 9100, "Low Value",     IF (         'Cleaned Sales Data'[Total Sales] <= 330000, "Mid Value",         "High Value"     ) ...
  • Anonymous's avatar
    Anonymous
    2 years ago

    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.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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.