Forum Discussion
chart suggestion
Hi poojayadav22 ,
Try Charticulator, Chart Templates , Line and Clustered COlumn Chart(there is an option for error bars).
please give kudos or mark it as solution once confirmed.
Thanks and Regards,
praful
Hi poojayadav22 ,
As mentioned by Praful_Potphode try their recommended visuals Charticulator, Chart Templates , Line and Clustered Column Chart.
If you want to represent quartile1, quartile3 you can also check out donut chart, which is a built in visual in Power BI.I hope this information helps. Please do let us know if you have any further queries.
Thank you
Hi poojayadav22 , you can try xViz Box and Whisker Chart for this, here are the steps below to do so :
Go to AppSource → “xViz Box and Whisker Chart” → Add.
In Power BI Desktop:
Category field: dimension (e.g., department, region)
Values field: your metric (used to calculate quartiles automatically)
Under Plot Settings → Orientation → Horizontal
To add your circle (score):
Add your “User Score” as a custom data point / reference line.
Choose Marker shape = circle.
⭐Hope this solution helps you make the most of Power BI! If it did, click 'Mark as Solution' to help others find the right answers.
💡Found it helpful? Show some love with kudos 👍 as your support keeps our community thriving!
🚀Let’s keep building smarter, data-driven solutions together!🚀 [Explore More]
i do not want to show whisker lines can you see the image that i shared with you
- You can remove whiskers
In the Format Pane (paint roller icon):
Expand Box Options
Turn off:
Show whiskers → Disable
Display outliers → Disable (if visible)
Set Box Fill = On, adjust color/transparency as desired.
Now your chart will show only the box between Q1–Q3 with the median line.
- Add Your Circle (Score Marker)
Add a new Custom Data Point / Reference Line
Choose:
Value: Your Score field or a measure
Marker shape: Circle (⚪)
Marker color: Distinct (e.g., blue)
Line style: None (you only want the circle)
In Plot Settings → Orientation, select:
Horizontal (default vertical → switch to horizontal)
i have four measures and i am using box and whiskers by maq software in this chart i cannot add my all four measures. which chart are you suggesting
You can try building custom xViz Box and Whisker chart by following steps :
- Get the visual:
→ AppSource → “xViz Box and Whisker Chart” → Add. - Switch to Custom Mode:
In Format Pane → Data Fields → Quartile Type → Select “Custom”.
This lets you manually provide Q1, Q3, and Median values. - Add your measures:
Category → e.g., “Region” or “Team”
Q1 → Your Q1 measure
Median → Your Median measure
Q3 → Your Q3 measure
Custom Data Point → Your “Score” measure - Turn off whiskers:
Format Pane → Box Options → Show whiskers → Off - Set horizontal layout:
Format Pane → Plot Settings → Orientation → Horizontal
( Assuming :You have 4 measures:
Q1 (25th percentile)
Median (50th percentile)
Q3 (75th percentile)
Score (actual / user value) )
- Get the visual:
- You can remove whiskers