Posts filed under DAX

Fixed-Window Charting in Power BI: Auto-Adjusting Calendar Periods

Video by: Reid Havens

Learn how to create a chart that always displays the same number of calendar periods, driven by slicer period selection, and regardless of if there is existing data (yet) for a period. This leverages a [DAX] generated table, relationships, and some auto-magic features. Tune in to learn more!

RELATED CONTENT 🔗

Creating a MTD/QTD/YTD Time Intelligence Slicer

Posted on January 28, 2025 and filed under DAX, Data Modeling, Visualizations.

Waterfall Charts with Categories (and Considerations...)

Video by: Reid Havens

As a follow up to a my previous video on creating an enhanced vertical/horizontal waterfall chart. In this video I'm going to show you that it's "possible" to create a categorical waterfall chart, but with a few considerations and caveats. Tune in to learn more!

RELATED CONTENT 🔗

Vertical Waterfall Charts with Visual Calcs

Box (and Whisker) Plot Visual with Native Visuals + Error Bars

Video by: Reid Havens

Learn how to leverage error bars and native visualizations to create a box and whisker style visualization using a bit of [DAX] magic. Tune in to learn more!

RELATED CONTENT 🔗

Create a Range Bar with Native Visuals
Box Chart
Daniel’s GitHub (PBIX File)
Daniel's Website
Deneb

Posted on December 17, 2024 and filed under Visualizations, DAX.

Power BI Upgrade: Easy Vertical Waterfall Charts with Visual Calcs

Video by: Reid Havens

Learn how to build a dynamic vertical waterfall chart using Power BI's native stacked column visual and visual calculations. This step-by-step tutorial covers setting up the data, creating measures using the RUNNINGSUM() function, and handling common challenges such as cumulative calculations and visual formatting. Perfect for showcasing trends, financial analysis, or any scenario requiring clear visualization of increases and decreases over time.

🔍 In this video, you’ll discover:

  • How to create a vertical waterfall effect with transparent base calculations

  • Tips for using visual-level DAX functions efficiently

  • Techniques for handling monthly data and segment slicing

📊 Level up your data visualization skills with this powerful technique for clearer and more effective storytelling in Power BI!

RELATED CONTENT 🔗

Understanding Visual Calculations - Microsoft Learn

Posted on December 10, 2024 and filed under DAX, Visualizations.