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 All,
I need some assistance with the quadrant chart representation.
I have the below data which I want to present in the Quadrant chart. On one axis I want priority and on other axis I want effort estimate. Bubbles should display the short description and its count in each quadrant.
I tried to use the custom visual , but it was not successful.
The problem is, the axis are not showing as the string values, it shows as count.
The Hit list groups table is missing a suitable unique field to link back to the hit lists. It should not contain the EffortEstimate column. Maybe just a numeric version of the priority column?
You may want to re-watch this video Quadrant Chart by MAQ Software - Power BI Visual Introduction - YouTube
Hi,
There is no visual i see on the HIT List tab.
Thanks Ashish,
I have done that yesterday
Priority - P1 = 1, P2 = 2, P3 = 3, P4 = 4, P5 = 5.
Effort Estimate = Small = 1, Medium = 2, Large = 3, Extra large = 4
The problem is that, the bubbles show a summarised value, I don't get a seperate bubble for each task, and I dont seem to be able to label it.
By the way, I am using reporting server version of power bi.
Regards,
Swapnil
Hi,
Could you share the link from where i can download your PBI file.
Hi,
A quadrant chart is a scatter chart with 4 compartments. A scatter chart must have numerical fields in the X and Y axis. So you will have to convert your 2 fields to numerical values.
What would be your desired definitions (and sort order) for the X and Y axes ?
Hi There, Thank you looking into this.
On x- Axis I want priority and on Y axis I want Effort estimate.
Priority of 1 is critical and it keeps decreasing. So priority of 5 is extremly low. Priority values are P1 to P5.
Effore estimate scale is - small, medium, large and extra large.
Below is the switch statement I wrote to give the quadrant of the combination of priority and effort estimate. Please ignore the table name.
The combination should read like,
If priority is P1 and effort estimate is small, then it should fall in "Quick wins" quadrant.... and so on.
Hope this gives you enough information.
Regards,
SwapnilS
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 |
---|---|
97 | |
96 | |
81 | |
74 | |
66 |
User | Count |
---|---|
126 | |
106 | |
105 | |
86 | |
72 |