plot a measure on chart

[anupampandey]

Hi Team,

I am having a measure which actually a range. I'm unable to plot this measure on chart. Below is the measure. 

Avg. Commission Bucket = SWITCH(TRUE(),[Avg. Commission]>=2500, "A",[Avg. Commission]>=1500,"B",
[Avg. Commission]>=1000, "C",
[Avg. Commission]>=750, "D","F")

What I want is to get the number of outlets against each bucket?

Could anyone help me on this please?

Thanks,

Anupam

[v-jiascu-msft]

@anupampandey

Hi,

Could you please tell me if your problem is solved? You can mark the right answer to help others if it's convenient for you.

Best Regards!

Dale

[anupampandey]

Hi Dale,

My problem already get resolved. I had taken the solution as accepted. Today again I did accept solution as accepted.

Sorry for not responding in time.

Regards,

Anupam

[v-jiascu-msft]

@anupampandey

This formula looks more like a calculated column. Which chart do you want? If you want to use Stacked Column Chart, you can drag Avg. Commission Bucket to Axis and Value, then choose count.

 

Best Regards!

Dale