New DAX! User-Defined Functions
Now you can create your own DAX functions, reuse them in your reports, and share them with the community. Power BI Desktop: File | Options … Read More
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