Combining a numeric range parameter to highlight a column bar in a visual to help an audience focus their attention on a particular year while presenting the values depicted with potentially data storytelling techniques. Many thanks to Carlos Bérgamo for his tutorial on spotlighting a visual and Fernan Espejo for sharing that you can use the hex code option RGBA(0,0,0,0) on DAX formulas from this amazing tutorial.
Disclaimer: This report is for research and educational purposes only and is not intended to be a tool for decision-making. There are many uncertainties and debates about the details of mass shootings and gun violence in the United States of America and there are many limitations to this simple report. I'm not a criminologist or a statistician, nor do I intend to play one on TV.
You can download the pbix file below. Feel free to poke it.
eyJrIjoiM2RmM2ExOWEtZjA1NC00YTAyLWIyYTktOGQ1OTA2YjAyOGQ3IiwidCI6IjEwZWM3OTJjLTU4NzctNGU1ZS05OGE5LTFiMWQ3YTNjM2RlYiIsImMiOjR9
