2023 Week 11 | Power BI: Determining trend with LINEST
Determining trend for use in smart narratives with DAX LINEST and Power BI
Determining trend for use in smart narratives with DAX LINEST and Power BI
Introduction This week for Workout Wednesday we will be trying our hand at non-linear regression with the Deneb custom visual. With Vega and Vega-Lite we can create a non-linear line of best fit over our data points and utilise the statistical API to return a correlation coefficient. Requirements Power Query Obtain the dataset from the …
Introduction During week 42’s community month challenge brought to us by Thys van der Westhuizen – Thys built on my week 37 challenge – My First Deneb. For that week’s challenge I built out three basic bar charts using Deneb visuals, and subsequently, Thys continued to build a few more amazing visuals in his challenge. …
Introduction I sit back every week and watch the other amazing members of the #WorkoutWednesday Power BI team go through Deneb challenges like it’s nothing. The visuals are fantastic, the customizations are intriguing, but the truth is – I’ve never done a Deneb visual! Until this week that is. If you’re like me and …
Introduction This week we are exploring another lesser used chart type: the comet chart. Comet charts show the evolution of one or two measures over time. They allow you to see change between two time periods across a category while emphasizing the direction of the change. You might use a comet chart instead of a dumbbell …