Posts filed under Slicers & Filters

Creating a Calendar Slicer from a Matrix Table! (with Erik Svensen)

Video by: Reid Havens

Join Erik Svensen and I as Erik walks through how to transform a native matrix visual into a powerful Calendar type filter for your visuals! Where you can slice by date, day of week, week period of year, and more. Tune in for the demo!

GUEST BIO (Erik Svensen)👤

Erik Svensen is a Microsoft MVP. Erik has been working with the Microsoft BI stack for more than 20 years - starting with out with Excel and Microsoft Query for over 25 years ago. He owns the company CatMan Solution who is now serving over 70+ FMCG suppliers with a Power BI solution that provides the supplier with valuable insights in their performance at store level based on point of sales data provided to them by different retailers. He started the Danish Power BI User group and speaks at conferences and meetups. Another great passion besides Power BI is his collection of Danish contemporary art. And if he finds time he occasionally blogs about Power BI as well.

RELATED CONTENT 🔗

Erik's Blog
Erik's LinkedIn
CatMan Solutions

Cross-Highlighting a Visual Using a Slicer ?!?

Video by: Reid Havens

Learn how to leverage some recent native visual features plus a little bit of [DAX] magic to use a slicer to create a cross-highlight effect on a visual. Cross-highlighting is normally only natively available between visuals, not slicers. So tune into learn more!

Posted on July 2, 2024 and filed under Slicers & Filters, DAX, Visualizations.

Different Approach to a Auto-Scaling Date Axis in Power BI

Video by: Reid Havens

Learn about an updated technique I applied after getting inspiration from another YouTube video showing this original technique. This approach achieves the result of a dynamic date axis that scales to your filtered date range, but with less model additions than the original approach. But while still using Field Parameters and some clever DAX. Tune in to learn more!

RELATED CONTENT 🔗

Original Technique (SMART Axis Magic)