[verb] Mac·Gy·ver | mə-ˈgī-vər | MacGyvered | MacGyvering | MacGyvers
“Make or repair (an object) in an improvised or inventive way, making use of whatever items are at hand.” - Merriam-Webster
“[Using] the formatting options for Power BI visuals in unorthodox ways to achieve the result we want.” - Kurt Buhler
Every now and again, I'll come up with something using core visuals that might be handy for other folks to look at, adapt and make way better than I can. I hope that you find them useful!
A clustered bar chart, statistical measures, and error bars are used to create a layered box and whisker plot. While we could do this with a custom visual (or R/Python) using minimal effort, we can be constrained by the amount of data we can add to its dataset before Power BI will cap it, so if we have millions (or billions) of data points we want to evaluate, we can do this very quickly using DAX to compute the statistics and then using error bars to create the primitive shapes needed for a box and whisker plot and bind their attributes to these measures.