Customer Segmentation doesn't show up

[lamia89]

Customer Segmentation =

IF (

    'Cleaned Sales Data'[Total Sales] <= 9100, "Low Value",

    IF (

        'Cleaned Sales Data'[Total Sales] <= 330000, "Mid Value",

        "High Value"

    )

)

I used this dax but still nothing appear in pie chart and I can't figure out the issue, any support?

[Anonymous · Accepted solution]

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.

[lamia89]

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 

[Anonymous]

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