Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
Anonymous
Not applicable

Visualise distributions with pre-summarised data

G’day everyone,

 

New user of Power BI and first-time poster.

 

I want to know how I can create a visualisation of key distribution statistics (e.g. minimum, first quartile, medium, third quartile and maximum) using data that has already been summarised?

 

For example, consider the data example in the first screenshot below. I can use excel to show these statistics as a box and whisker plot that dynamically responds to the filters I’ve applied (see second screenshot below).

 

Data screenshotData screenshot

 

Plot screenshotPlot screenshot

 

Is it possible to do something similar in Power BI? The only non-negotiable constraint is that the data is already summarised (like the example in the first screenshot). The visualisation doesn’t have to be a box and whisker plot, just something that highlights the distribution. The structure of the data set can also be different (e.g. the summary statistics can be restructured as columns rather than rows as they are in the example attached).

 

Thanks in advance for all your help!

 

PS: This forum would be even better if members could post files so responders had access to sample data or other reference material.

0 REPLIES 0

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Kudoed Authors