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

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

Reply
RhodesE
New Member

Replicating a Data Visualization from the Book 'The Big Book of Dashboards': First Scenario

I've been reading The Big Book of Dashboards: Visualizing Your Data Using Real-World Business Scenarios. The first scenario in the book has this visual:

Sample from Book.png

 

The feedback ratings for three different groups are given:

  • Ratings for the entire college
  • Ratings for the department of Business Analytics (BANA)
  • Ratings for the particular instructor for the course selected (Shaffer)

 

Each average rating category/group is a different shape. The range of the ratings are connected by a line.

 

The generic Desktop Power BI defaul visuals don't seem to be able to do anything simliar to this. The book calls this a 'dot plot'. Searching the store for this does not seem to bring up anything simliar. Scatter plot seems like it would work at first glance, but doesn't seem to allow categorical values into the Y Axis perhaps (based on my experimentation)?

 

Any suggested free visuals in the marketplace to replicate something like this in Power BI?


My instinct says a bullet chart would be the alternative way to visualize this in Power BI. But just curious if it is possible to replicate it as it is visualized in the book.

2 REPLIES 2
Shaurya
Memorable Member
Memorable Member

Hi @RhodesE,

 

What if you use a scatter plot with the questions on your X-Axis, rating on Y and then use the category in legends. That would show the three different ratings along a line separated by colours.

 

Mark this post as a solution if that works for you!
Check out this blog of mine: How to Export Telemetry Data from Azure IoT Central into Power BI

You mentioned putting the questions on the X-Axis...

 

But, the scatter plot does not allow non-numerical values in the X or Y axis.

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.

ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.