Workout Wednesday 2026 | Week 30 | LOESS (LOWESS) Smoothing Using Pure DAX & Core Power BI Visuals

This week's Workout Wednesday challenge focused on implementing LOESS (Locally Estimated Scatterplot Smoothing) using only DAX measures and native Power BI core visuals.

In this solution, I:

• Implemented a dynamic LOESS smoothing algorithm entirely in DAX.
• Added a dynamic Bandwidth parameter to interactively control the smoothing level.
• Calculated the Neighbour Count dynamically based on the selected bandwidth.
• Built the visualization using only native Power BI visuals without custom visuals.
• Added interactive KPI cards, slicers, and explanatory text to improve usability and understanding.

This challenge was an excellent opportunity to explore advanced DAX techniques, local weighted regression, and interactive analytical storytelling in Power BI.

Tools Used: Microsoft Power BI Desktop (July 2026), DAX, Core Visuals

#WorkoutWednesday #WOW2026 #DataDays
#DAX #DataVisualization #FabricCommunity