Forum Discussion

anupampandey's avatar
anupampandey
Icon for Helper III rankHelper III
9 years ago

plot a measure on chart

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

Need Help

3 Replies

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    9 years ago

    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

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    9 years ago

    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's avatar
      anupampandey
      Icon for Helper III rankHelper III
      9 years ago

      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