topic Customer Segmentation doesn't show up in DAX Commands and Tips

Customer Segmentation doesn't show up

lamia89 — Thu, 11 Jul 2024 17:27:16 GMT

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?

Re: Customer Segmentation doesn't show up

Anonymous — Fri, 12 Jul 2024 01:33:47 GMT

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

Re: Customer Segmentation doesn't show up

lamia89 — Sat, 13 Jul 2024 09:06:01 GMT

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

Re: Customer Segmentation doesn't show up

Anonymous — Thu, 25 Jul 2024 06:00:11 GMT

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.