Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
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 screenshot
Plot 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.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.