The total row in a Power BI table: Is it wrong?
The total row in a Power BI table: Is it wrong? Let me tell you about the complexity of DAX, misleading terms like aggregators and … Read More
Power BI Embedded Demo
All other reports on my website use Publish to Web (unsecure way to publish public open-data and dummy-data reports). This one is a truly securely embedded … Read More
Fabric Deployment Pipeline Rule to set Data Pipeline Parameters
+ Deployment Stage Conditional Formatting in Power BI Reports I probably should give the Fabric Variable libraries (preview) a try. But a preview is essentially … Read More
WoW 2025 Week 24 | Power BI Core Slicers Box Plot
I don’t often join Workout Wednesday, but when I do, I prefer unconventional solutions. This week, WoW is about PBI Core Visuals, but slicers are … Read More
Row Level Security → Default Slicer Selection
One more experiment with the Button Slicer: Row-Level Security (RLS)-based default slicer selection (for cases where security isn’t required but a default selection is desired). … Read More
Power BI – Date Slicer with Default Selection
Magic of the new Power BI Button Slicer: the current calendar month is always selected by default. In the video, I change the system date, … Read More
Multiple Stars in a Star Schema
Power BI developers learn that a star schema is the optimal data model design for usability and performance. However, seeing an ideal “star schema” with … Read More
M Language Function to Call Open AI API from Power Query
I’ve published a new version of the fxOpenAI function for Power Query. https://github.com/avatorl/M/blob/master/fx/fxOpenAI.m How to use System prompt is optional. Default system prompt: “You’re a … Read More
AI Assistant for Tabular Editor
For now, this is just a quick proof of concept, but it works (at least it worked on my side). It consists of two C# … Read More
Solid, outlined, hatched: How visual consistency helps better understand reports, presentations and dashboards
Rolf Hichert and Jürgen Faisst’s Solid, Outlined, Hatched is an incredibly practical book about visual consistency that helps readers better understand reports, presentations and dashboards. … Read More