A Fine Slice Of SQL Server
Boniface Muchendu creates a Pareto chart:
Creating a Pareto chart in Power BI is a powerful way to visualize the 80/20 rule in action. This type of chart helps you quickly identify the top contributors to your business metrics—whether you’re analyzing sales, categories, or customer segments. In this guide, you’ll learn how to build a dynamic Pareto chart using DAX, customize it, and apply it across different data dimensions.
Read on for the instructions.
Leave a CommentA major update to
ggplot2(version 4.0.0) is expected around mid-to-late July 2025. It brings a significant internal change, replacing most of the S3 backend with the newer S7 object system. While this improves long-term maintainability and extensibility, it may break Bioconductor packages that depend onggplot2, especially those that customise how plots are built or styled. Packages that useggplot2for typical plotting tasks, such as creating plots withggplot()andgeom_*(), are unlikely to be affected.
Click through for notes, tips on what to do, and whether the code you’re using will break with ggplot2 4.0.0. H/T R-Bloggers.
Leave a CommentElena Drakulevska has some thoughts on drop shadows:
I get why people add them. Shadows might feel like a design upgrade. A quick way to make your visuals pop or feel more “finished.”
But here’s the thing: just like rounded corners, drop shadows are easy to overdo—and they’re not actually helping. Not with clarity. Not with accessibility. Definitely not with UX.
Click through for Elena’s full thoughts. I’m generally against drop shadows. They draw visual attention without providing the report viewer any value. That’s chartjunk.
Leave a CommentBoniface Muchendu lets users pick the date:
Many users need the ability to select a single date not a range to filter their entire report. While Power BI’s default slicer shows a long list of dates or uses relative filters like “Today” or “Yesterday,” these options can be limiting.
Additionally, relying on the filter pane often isn’t ideal for dashboards meant for end users, especially when the pane is hidden or locked. An on-screen date picker provides a more intuitive and controlled experience.
Read on to see how.
Comments closedElena Drakulevska explains why padding is so important between visuals in Power BI reports:
Now that we’ve all learned to love rounded corners, let’s talk about another quiet champion of good design: padding.
You know, that tiny bit of space inside your visuals that keeps content from being awkwardly pressed right up against the border, with no room to breathe. Yeah. That.
The ideal here is to have densely informative visuals that have sufficient padding to make it easy for a viewer to move between them.
Comments closedA quadrilateral is a polygon having four sides, four angles, and four vertices. A polygon means that the figure is a closed shape, meaning the last line segment connects back to the first one, effectively enclosing an area.
We usually think of quadrilaterals as squares, rectangles, parallelograms, trapezoids, rhombuses, or kites. (I was impressed that my four year-old granddaughter knew the last one, although she called it a diamond!) It could also be irregularly shaped with no name.
However, a polygon may intersect itself.
Click through for a demonstration of a self-intersecting quadrilateral, including the R code you can use to try it out yourself.
Comments closedElena Drakulevska has a checklist for us:
Whether you’re designing for executives using tablets, keyboard-only users, or screen reader tech, accessibility is not a nice-to-have. It’s a design standard.
Here’s the accessibility checklist I use in client projects and workshops—and now it’s yours too!
Click through for some good advice on how to make your Power BI dashboards and reports easy to use.
For another take on the topic, I recommend reviewing Meagan Longoria’s checklist as well.
Comments closedKevin Wilkie watches a moth fly out of his wallet and wonders where all of the money went:
Last time, in Dashboard Dreams and Snowflake Schemes, we talked a little about showing how much Snowflake really costs in a dashboard internal to Snowflake itself instead of having to push it to PowerBi, Tableau, Looker, or a myriad of other tools.
This time, let’s take it a step further: instead of sticking with the basic bar charts or exploding pie charts, we’ll explore how to better highlight usage trends by adding a Rolling 7-Day Average to our visualizations. This helps us more easily spot patterns and anomalies within our warehouses.
Read on for a pair of queries and a neat chart.
Comments closedMauricio Vargas S. shows correlation:
spuriouscorrelations package started as a fun project for one of my tutorials.
Here is a case of an interesting correlation: the number of people who drowned by falling into a pool and the number of films Nicholas Cage appeared in.
Click through for examples and how to use the package. If you’re interested in more of these, Tyler Vigen’s website has plenty, and he even wrote a book. H/T R-Bloggers.
Comments closedElena Drakulevska explains that you can’t succeed without both:
There’s this UX law called the Aesthetic-Usability Effect. And it basically says:
People will lean more toward better-looking products—even if they’re not the best-performing ones.
Sounds wild, right? But it’s true. A gorgeous report might win hearts even if a more useful, but less attractive one, is sitting in the corner gathering dust.
And honestly? I agree… to a point.
Read on to see when it falls apart and why you can’t focus solely on one or the other. Utility curves are convex, after all.
Comments closed