Uploaded September 2026 | Updated November 2026, 1 day ago
Plenty of Power BI issues that look like DAX issues start one layer down, in the model. The formula is correct, the relationship underneath it isn't doing what you assumed, and you spend an afternoon rewriting a measure that was never the problem.
This one covers the foundation the rest of it sits on. Why a model beats one giant flat table (smaller storage, better compression, faster refresh, and filter paths you get without writing any code), how dimensions and facts split the who-what-when-where from the numeric events, and what actually happens when someone picks a value in a slicer and that filter travels down the relationship into the fact table.
Then star versus snowflake, compared on the four things that decide it in practice: query performance, DirectQuery latency, how long the DAX ends up, and whether business users can find a field without asking someone. Star wins on all four. I also get into why the snowflake version keeps turning up anyway, since it usually arrives from a source system rather than from a decision anyone made.
The last section is the one that gets skipped. Every visual in Power BI generates a query with three ingredients (filter, group, summarize), and once that clicks, a wrong number stops being mysterious. After that it's the fields list itself: friendly names instead of cgo_key_fk, display folders, hidden keys, and descriptions that surface as tooltips. It sounds cosmetic, but an unreadable fields list is how you end up with six competing Excel copies of the same report.
CHAPTERS π¬
00:00 -- Why a fundamentals video
01:00 -- Why model data
02:01 -- Dimensions & facts
03:44 -- Filter flow
04:58 -- Star vs snowflake
07:00 -- Analytic queries
08:45 -- Intuitive fields list
RELATED CONTENT π
Modeling Fundamentals Guide -- go-ae.org/hc-yt-modeling-fundamentals-guide
BECOME A CHANNEL MEMBER π
-- youtube.com/channel/UCjlfQwqb-0S40XQ8seYPLSw/join
CHECK OUT OUR MERCH STORE π
-- havens-consulting.creator-spring.com
LET'S CONNECT! π§π½βπ€βπ§π½ π
-- linkedin.com/in/reidhavens
-- youtube.com/c/HavensConsulting
BUSINESS PAGES π
Home Page -- havensconsulting.net/?utm_source=youtube-hc&utm_medium=video&utm_campaign=5jsemq2T1mM
Blog -- havensconsulting.net/blog-and-media?utm_source=youtube-hc&utm_medium=video&utm_campaign=5jsemq2T1mM
Blog Files -- havensconsulting.net/blog-files?utm_source=youtube-hc&utm_medium=video&utm_campaign=5jsemq2T1mM
Files & Templates -- havensconsulting.net/files-and-templates?utm_source=youtube-hc&utm_medium=video&utm_campaign=5jsemq2T1mM
Consulting Services -- havensconsulting.net/consulting-services?utm_source=youtube-hc&utm_medium=video&utm_campaign=5jsemq2T1mM
Online Courses -- havensconsulting.net/online-courses?utm_source=youtube-hc&utm_medium=video&utm_campaign=5jsemq2T1mM
Contact & Support -- havensconsulting.net/contact-and-support?utm_source=youtube-hc&utm_medium=video&utm_campaign=5jsemq2T1mM
Analytic Endeavors -- analyticendeavors.com/make-an-enquiry.html?ae_source=HC&utm_source=youtube-hc&utm_medium=video&utm_campaign=5jsemq2T1mM
EMAIL US AT π§
info@havensconsulting.net
#PowerBI #Fabric #microsoft #businessintelligence #datascience #data #dataanalytics #excel #datavisualization #dashboard #bi #analytics #powerquery #dax #microsoftfabric #semanticmodel
Plenty of Power BI issues that look like DAX issues start one layer down, in the model. The formula is correct, the relationship underneath it isn't doing what you assumed, and you spend an afternoon rewriting a measure that was never the problem.
This one covers the foundation the rest of it sits on. Why a model beats one giant flat table (smaller storage, better compression, faster refresh, and filter paths you get without writing any code), how dimensions and facts split the who-what-when-where from the numeric events, and what actually happens when someone picks a value in a slicer and that filter travels down the relationship into the fact table.
Then star versus snowflake, compared on the four things that decide it in practice: query performance, DirectQuery latency, how long the DAX ends up, and whether business users can find a field without asking someone. Star wins on all four. I also get into why the snowflake version keeps turning up anyway, since it usually arrives from a source system rather than from a decision anyone made.
The last section is the one that gets skipped. Every visual in Power BI generates a query with three ingredients (filter, group, summarize), and once that clicks, a wrong number stops being mysterious. After that it's the fields list itself: friendly names instead of cgo_key_fk, display folders, hidden keys, and descriptions that surface as tooltips. It sounds cosmetic, but an unreadable fields list is how you end up with six competing Excel copies of the same report.
CHAPTERS π¬
00:00 -- Why a fundamentals video
01:00 -- Why model data
02:01 -- Dimensions & facts
03:44 -- Filter flow
04:58 -- Star vs snowflake
07:00 -- Analytic queries
08:45 -- Intuitive fields list
RELATED CONTENT π
Modeling Fundamentals Guide -- go-ae.org/hc-yt-modeling-fundamentals-guide
BECOME A CHANNEL MEMBER π
-- youtube.com/channel/UCjlfQwqb-0S40XQ8seYPLSw/join
CHECK OUT OUR MERCH STORE π
-- havens-consulting.creator-spring.com
LET'S CONNECT! π§π½βπ€βπ§π½ π
-- linkedin.com/in/reidhavens
-- youtube.com/c/HavensConsulting
BUSINESS PAGES π
Home Page -- havensconsulting.net/?utm_source=youtube-hc&utm_medium=video&utm_campaign=5jsemq2T1mM
Blog -- havensconsulting.net/blog-and-media?utm_source=youtube-hc&utm_medium=video&utm_campaign=5jsemq2T1mM
Blog Files -- havensconsulting.net/blog-files?utm_source=youtube-hc&utm_medium=video&utm_campaign=5jsemq2T1mM
Files & Templates -- havensconsulting.net/files-and-templates?utm_source=youtube-hc&utm_medium=video&utm_campaign=5jsemq2T1mM
Consulting Services -- havensconsulting.net/consulting-services?utm_source=youtube-hc&utm_medium=video&utm_campaign=5jsemq2T1mM
Online Courses -- havensconsulting.net/online-courses?utm_source=youtube-hc&utm_medium=video&utm_campaign=5jsemq2T1mM
Contact & Support -- havensconsulting.net/contact-and-support?utm_source=youtube-hc&utm_medium=video&utm_campaign=5jsemq2T1mM
Analytic Endeavors -- analyticendeavors.com/make-an-enquiry.html?ae_source=HC&utm_source=youtube-hc&utm_medium=video&utm_campaign=5jsemq2T1mM
EMAIL US AT π§
info@havensconsulting.net
#PowerBI #Fabric #microsoft #businessintelligence #datascience #data #dataanalytics #excel #datavisualization #dashboard #bi #analytics #powerquery #dax #microsoftfabric #semanticmodel
![Box (and Whisker) Plot Visual with Native Visuals + Error Bars
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 https://youtu.be/vowoC_akDcA
Box Chart https://en.wikipedia.org/wiki/Box_plot
Daniels GitHub https://github.com/dm-p/pbi-core-visuals-macgyver
Daniels Website https://coacervo.co/
Deneb https://deneb-viz.github.io/
BECOME A CHANNEL MEMBER π
https://www.youtube.com/channel/UCjlfQwqb-0S40XQ8seYPLSw/join
CHECK OUT OUR MERCH STORE π
https://havens-consulting.creator-spring.com/
LETS CONNECT! π§π½βπ€βπ§π½ π
https://twitter.com/HavensBI
https://www.linkedin.com/in/reidhavens
https://www.youtube.com/c/HavensConsulting
https://www.facebook.com/havensconsulting
VIDEO CHAPTERS π₯
0:00 - Start of Video
0:30 - Content Intro
HAVENS CONSULTING PAGES π
Home Page - http://www.havensconsulting.net/?utm_source=youtube-hc&utm_medium=video&utm_campaign=67ZE4qCSSw4
Blog http://www.havensconsulting.net/blog-and-media?utm_source=youtube-hc&utm_medium=video&utm_campaign=67ZE4qCSSw4
Blog Files http://www.havensconsulting.net/blog-files?utm_source=youtube-hc&utm_medium=video&utm_campaign=67ZE4qCSSw4
Files & Templates http://www.havensconsulting.net/files-and-templates?utm_source=youtube-hc&utm_medium=video&utm_campaign=67ZE4qCSSw4
Consulting Services http://www.havensconsulting.net/consulting-services?utm_source=youtube-hc&utm_medium=video&utm_campaign=67ZE4qCSSw4
Online Courses https://www.havensconsulting.net/online-courses?utm_source=youtube-hc&utm_medium=video&utm_campaign=67ZE4qCSSw4
Contact & Support - http://www.havensconsulting.net/contact-and-support?utm_source=youtube-hc&utm_medium=video&utm_campaign=67ZE4qCSSw4
EMAIL US AT π§
info@havensconsulting.net
#PowerBI #powerplatform #microsoft #businessintelligence #datascience #data #dataanalytics #excel #powerapps #datavisualization #dashboard #bi #analytics #powerquery #dax #microsoftfabric #semanticmodel #boxplot #deneb Box (and Whisker) Plot Visual with Native Visuals + Error Bars](https://i.ytimg.com/vi/67ZE4qCSSw4/mqdefault.jpg)


![[DAX] Lib - From Zero to Community Hero (with Jake Duddy)
User-defined functions landed in DAX last September, and SQLBI launched DAXLib alongside them as a community repo for sharing libraries. There are already 30+ packages people can pull straight into their models. If youve built a UDF that made your own life easier, odds are someone else is working around the same problem.
This stream is about closing that gap. Jake Duddy joins me to walk through what it actually takes to turn a working UDF into a published DAXLib package that other people can install and use. Jake recently contributed EvaluationContext.Colour (a HEX manipulation library for SVG and conditional formatting work), so hes been through the workflow recently and has the bruises to show for it.
What well cover:
- DAXLib: what it is and why SQLBI built it
- Model-independent vs model-dependent functions, and which belong in a library
- Packaging a UDF for publication
- Submitting through GitHub
- What separates a useful contribution from noise
- Q&A throughout
GUEST BIO (Jake Duddy) π€
Jake Duddy is a Microsoft Data Platform MVP and Power BI SME based in Birmingham, UK. He runs the Evaluation Context blog covering Power BI, Fabric, DAX, and SSAS, and speaks regularly at SQLBits, the Power BI & Fabric Summit, and the Microsoft Data Platform Group Birmingham.
Links to DAXLib, Jakes blog, and his EvaluationContext.Colour library are in the comments.
#PowerBI #DAX #MicrosoftFabric #DAXLib #UDF
RELATED CONTENT π
DAX Lib https://daxlib.org/
Jakes LinkedIn https://www.linkedin.com/in/jakeduddy/
LETS CONNECT! π§π½βπ€βπ§π½ π
https://www.linkedin.com/in/reidhavens
https://www.youtube.com/c/HavensConsulting
HAVENS CONSULTING PAGES π
Home Page http://www.havensconsulting.net/?utm_source=youtube-hc&utm_medium=video&utm_campaign=6W25fR70lAk
Blog http://www.havensconsulting.net/blog-and-media?utm_source=youtube-hc&utm_medium=video&utm_campaign=6W25fR70lAk
Blog Files http://www.havensconsulting.net/blog-files?utm_source=youtube-hc&utm_medium=video&utm_campaign=6W25fR70lAk
Files & Templates http://www.havensconsulting.net/files-and-templates?utm_source=youtube-hc&utm_medium=video&utm_campaign=6W25fR70lAk
Consulting Services http://www.havensconsulting.net/consulting-services?utm_source=youtube-hc&utm_medium=video&utm_campaign=6W25fR70lAk
Online Course https://www.havensconsulting.net/online-courses?utm_source=youtube-hc&utm_medium=video&utm_campaign=6W25fR70lAk
Contact & Support http://www.havensconsulting.net/contact-and-support?utm_source=youtube-hc&utm_medium=video&utm_campaign=6W25fR70lAk
EMAIL US AT π§
info@havensconsulting.net
#PowerBI #Microsoft #DAX #SQLBI #UDF [DAX] Lib - From Zero to Community Hero (with Jake Duddy)](https://i.ytimg.com/vi/6W25fR70lAk/mqdefault.jpg)






