Blog | DataZoe Power BI

top of page

DataZoe Power BI

Search

KPIs in Power BI semantic models

KPIs in Power BI semantic models

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!

Sep 253 min read

Creating and editing Direct Lake semantic models

Creating and editing Direct Lake semantic models

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.

Jul 263 min read

Creating a perspective in Power BI Desktop with TMDL view

Creating a perspective in Power BI Desktop with TMDL view

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

Jul 197 min read

DAX Date table in Power BI shown in TMDL View

DAX Date table in Power BI shown in TMDL View

DAX Date table in TMDL

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

Feb 175 min read

DEFINE MEASURE in a DAX query of DAX query view in Power BI

DEFINE MEASURE in a DAX query of DAX query view in Power BI

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

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}

DAX query 101: Get and analyze data with EVALUATE, FILTER, SELECTCOLUMNS, SUMMARIZE, SUMMARIZECOLUMNS, ORDER BY, TOPN, START AT, and {table constructors}

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!

Jan 2616 min read

Keeping up with the Power BI Blog with Power Automate

Keeping up with the Power BI Blog with Power Automate

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

Jul 12, 20242 min read

Setting up RLS on a Direct Lake semantic model

Setting up RLS on a Direct Lake semantic model

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

Tabular Data Model

Jan 18, 202410 min read

Relationships DAX query (using INFO.RELATIONSHIPS)

Relationships DAX query (using INFO.RELATIONSHIPS)

Relationships DAX query (using INFO.RELATIONSHIPS)

Surface your relationship metadata with the new DAX INFO functions!

Dec 27, 20236 min read

bottom of page