top of page

Search


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 253 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 263 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 175 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 167 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 2616 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
Â
Â
Â


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
Â
Â
Â


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
Â
Â
Â


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

DataZoe
Apr 10, 20213 min read
Â
Â
Â


Working with DateID in Direct Query and Incremental Refresh
Scenarios when using DateTime to limit data and maintain query folding can be done with DateIDs! Two scenarios are (1) rolling x days of dat

DataZoe
Jan 30, 20214 min read
Â
Â
Â


Creating a slicer panel!
Many of my reports feature the slicer panel that hide/show on via a button.

DataZoe
Dec 20, 20203 min read
Â
Â
Â


Let's create a data model!
Tabular data modeling is key to making a report, and can be daunting at first. I'll show you how I approach making a tabular data model....

DataZoe
Dec 4, 202011 min read
Â
Â
Â
bottom of page