Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
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
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
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
99 | |
76 | |
64 | |
58 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |