top of page

Search


Deployment pipelines and Power BI semantic models with Direct Lake on OneLake tables
Use deployment pipeline rules with Direct Lake on OneLake tables in Power BI semantic models.

DataZoe
Dec 2, 20252 min read
Â
Â


Display units to none for all visuals with a custom report theme
Dynamic format strings for measures and dynamic format strings on calculation groups only really has one natural enemy in the report. Public enemy number 1 for dynamic format strings is display units setting on visuals! Lately I've been exporting themes for reports, and I realized I could have solved my own problems with a few lines of json. Here is the custom theme, which can be used on its own or incorporated into your own custom theme, to turn all visuals display units to

DataZoe
Nov 24, 20253 min read
Â
Â
Â


New card visual preview to GA impact FAQ
In November 2025, the new card visual, previously in preview, moved to general availability. A number of fixes and new functionality made it so existing reports using the preview card now will start to look different. Here is a list of the common impacts and the way to address them. Those only using the card after general availability will not be impacted. New card visual docs page: Create a card visual in Power BI - Power BI | Microsoft Learn Frequently asked questions for c

DataZoe
Nov 22, 20254 min read
Â
Â
Â


KPIs in Power BI semantic models
Key performance indicators (KPIs) are a way to set a target, as well as logic and graphics to show for status and the trend for any measure in a Power BI semantic model. Create them in TMDL view!

DataZoe
Sep 25, 20253 min read
Â
Â
Â


Creating and editing Direct Lake semantic models
Semantic models with Direct Lake tables have two flavors and can be edited in both web modeling and Power BI Desktop.

DataZoe
Jul 26, 20253 min read
Â
Â


Perspectives in Power BI semantic models
Let's take a look at these perspective topics in this blog post: 1. Hiding vs perspectives, 2. Authoring in Power BI Desktop with TMDL view, 3. Using perspectives in live connect reports in Power BI Desktop, 4. Using perspectives in the Personalized visuals feature, and 5. Analyzing perspectives with a DAX query

DataZoe
Jul 19, 20257 min read
Â
Â
Â


DAX Date table in TMDL
My date table now in TMDL with sort by columns, format strings, descriptions, folders, and hierarchy.

DataZoe
Feb 17, 20255 min read
Â
Â


DAX query 102: DAX formulas and measures with DEFINE MEASURE
There is a now a DAX query view in Power BI and let's get you started querying your data with whatever formula you need defined in the...

DataZoe
Feb 16, 20257 min read
Â
Â
Â


DAX query 101: Get and analyze data with EVALUATE, FILTER, SELECTCOLUMNS, SUMMARIZE, SUMMARIZECOLUMNS, ORDER BY, TOPN, START AT, and {table constructors}
Let's get you started querying your data to get the analysis you are looking for!

DataZoe
Jan 26, 202516 min read
Â
Â


Keeping up with the Power BI Blog with Power Automate
Before I joined the Power BI product group, I had a friend show me how to have the Power BI blogs show up in a Teams channel. You can...

DataZoe
Jul 12, 20242 min read
Â
Â
Â


Setting up RLS on a Direct Lake semantic model
Power BI semantic models have the option to set up row level security (RLS). And this includes Direct Lake Power BI semantic models in...

DataZoe
Jan 18, 202410 min read
Â
Â
Â


Relationships DAX query (using INFO.RELATIONSHIPS)
Surface your relationship metadata with the new DAX INFO functions!

DataZoe
Dec 27, 20236 min read
Â
Â
Â


Generate a Power BI Direct Lake data model in Fabric
One of the cool things about having a notebook inside a Power BI workspace is all the cool things pyspark can do. I wanted a way to...

DataZoe
Jul 10, 20236 min read
Â
Â
Â


Add filter to show current user items or all items
I ran into a request recently to filter to current user only items but also allow them to see all items. I at first thought of row-level...

DataZoe
Feb 1, 20221 min read
Â
Â
Â


Same period last year with partial periods
I was helping a friend today with how do we compare partial month this year to just the same partial month last year scenario. When we...

DataZoe
Oct 25, 20211 min read
Â
Â
Â


DAX Date Table
There are a lot of different Date tables out there, and this is mine! This one features things I add in many of my reports, which is a...

DataZoe
Jul 31, 20212 min read
Â
Â


Report overlay to highlight report features
When I show a report to someone, I find myself pointing to parts of the report and explaining what they do, here I add an overlay to do it.

DataZoe
Jun 10, 20214 min read
Â
Â
Â


Allowing your end users to Refresh Power BI data with Power Automate
There are some reports where I have a schedule refresh but I also want to bring in new data whenever I happen to be looking at the...

DataZoe
May 2, 20212 min read
Â
Â
Â


Buttons to highlight a selected measure!
Use buttons to highlight which selected measure is being used!

DataZoe
Apr 10, 20213 min read
Â
Â
Â


Switch between fiscal and regular calendar via slicer
I recently answered a request for this on the Power BI Community forums and thought I would share how to implement this in more detail....

DataZoe
Feb 25, 20214 min read
Â
Â
Â
bottom of page