Forum Discussion

anupampandey's avatar
anupampandey
Helper 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
    Microsoft 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
    Microsoft 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
      Helper 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