top of page
![DataZoe Power BI](https://static.wixstatic.com/media/991134_6cf2cc236ac141f7bc9d6bc3b93c4658~mv2.png/v1/fill/w_268,h_93,al_c,q_85,usm_0.66_1.00_0.01,enc_avif,quality_auto/logo_transparent_background.png)
Search
![Keeping up with the Power BI Blog with Power Automate](https://static.wixstatic.com/media/991134_1f938519ba884b7ea40ca8182e5cb3ba~mv2.png/v1/fill/w_292,h_219,fp_0.50_0.50,q_95,enc_auto/991134_1f938519ba884b7ea40ca8182e5cb3ba~mv2.webp)
DataZoe
Jul 12, 20242 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...
1680
![Setting up RLS on a Direct Lake semantic model](https://static.wixstatic.com/media/991134_03bace0eee3940dca530ecf093f6fb85~mv2.png/v1/fill/w_292,h_219,fp_0.50_0.50,q_95,enc_auto/991134_03bace0eee3940dca530ecf093f6fb85~mv2.webp)
DataZoe
Jan 18, 202410 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...
5,8260
![Relationships DAX query (using INFO.RELATIONSHIPS)](https://static.wixstatic.com/media/991134_8b13cfd35add4497882136d4d3daf541~mv2.png/v1/fill/w_292,h_219,fp_0.50_0.50,q_95,enc_auto/991134_8b13cfd35add4497882136d4d3daf541~mv2.webp)
DataZoe
Dec 27, 20236 min read
Relationships DAX query (using INFO.RELATIONSHIPS)
Surface your relationship metadata with the new DAX INFO functions!
1,6980
![Generate a Power BI Direct Lake data model in Fabric](https://static.wixstatic.com/media/991134_30a642e736f14fd6b22931a4192605ee~mv2.png/v1/fill/w_292,h_219,fp_0.50_0.50,q_95,enc_auto/991134_30a642e736f14fd6b22931a4192605ee~mv2.webp)
DataZoe
Jul 10, 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...
1,0070
![Add filter to show current user items or all items](https://static.wixstatic.com/media/991134_baae7f1ca8464ab297ebe412c500348f~mv2.webp)
DataZoe
Feb 1, 20221 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...
4,4170
![Same period last year with partial periods](https://static.wixstatic.com/media/991134_c82dbc00199244b2ac41242452dcd164~mv2.png/v1/fill/w_292,h_219,fp_0.50_0.50,q_95,enc_auto/991134_c82dbc00199244b2ac41242452dcd164~mv2.webp)
DataZoe
Oct 25, 20211 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...
5130
![DAX Date Table](https://static.wixstatic.com/media/991134_3656ca153a294c6aaf2fb2b2f9327123~mv2.png/v1/fill/w_292,h_219,fp_0.50_0.50,q_95,enc_auto/991134_3656ca153a294c6aaf2fb2b2f9327123~mv2.webp)
DataZoe
Jul 31, 20212 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...
1,800
![Report overlay to highlight report features](https://static.wixstatic.com/media/991134_7dbcd62244ca49329be8466ee90dc0a4~mv2.png/v1/fill/w_292,h_219,fp_0.50_0.50,q_95,enc_auto/991134_7dbcd62244ca49329be8466ee90dc0a4~mv2.webp)
DataZoe
Jun 10, 20214 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.
1,6230
![Allowing your end users to Refresh Power BI data with Power Automate](https://static.wixstatic.com/media/991134_ed26519163c546efa8b393d2a4cbc150~mv2.webp)
DataZoe
May 2, 20212 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...
3,9740
![Buttons to highlight a selected measure!](https://static.wixstatic.com/media/991134_2574bc5161f34711b970cc48c1f5e658~mv2.webp)
DataZoe
Apr 10, 20213 min read
Buttons to highlight a selected measure!
Use buttons to highlight which selected measure is being used!
1,8720
![](https://static.wixstatic.com/media/991134_8fb50ba36b034f2ca1c41d6bf61b2482~mv2.jpg/v1/fill/w_250,h_250,fp_0.50_0.50,q_30,blur_30,enc_auto/991134_8fb50ba36b034f2ca1c41d6bf61b2482~mv2.webp)
![Switch between fiscal and regular calendar via slicer](https://static.wixstatic.com/media/991134_8fb50ba36b034f2ca1c41d6bf61b2482~mv2.jpg/v1/fill/w_292,h_219,fp_0.50_0.50,q_90,enc_auto/991134_8fb50ba36b034f2ca1c41d6bf61b2482~mv2.webp)
DataZoe
Feb 25, 20214 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....
2,8920
![Working with DateID in Direct Query and Incremental Refresh](https://static.wixstatic.com/media/991134_d9bb208367904ead8dc53884cc5bee21~mv2.png/v1/fill/w_292,h_219,fp_0.50_0.50,q_95,enc_auto/991134_d9bb208367904ead8dc53884cc5bee21~mv2.webp)
DataZoe
Jan 30, 20214 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
2580
![Creating a slicer panel!](https://static.wixstatic.com/media/991134_b5ea91b1e7ac430e938a1a24778f9e62~mv2.webp)
DataZoe
Dec 20, 20203 min read
Creating a slicer panel!
Many of my reports feature the slicer panel that hide/show on via a button.
1,2720
![Let's create a data model!](https://static.wixstatic.com/media/991134_34f67543ca234dc5b94c3457c94b0449~mv2.png/v1/fill/w_292,h_219,fp_0.50_0.50,q_95,enc_auto/991134_34f67543ca234dc5b94c3457c94b0449~mv2.webp)
DataZoe
Dec 4, 202011 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....
8080
![Power BI Buttons - Page Navigation with Icons](https://static.wixstatic.com/media/991134_be54e31a7a3242d1950c60b853431b88~mv2.png/v1/fill/w_292,h_219,fp_0.50_0.50,q_95,enc_auto/991134_be54e31a7a3242d1950c60b853431b88~mv2.webp)
DataZoe
Nov 29, 20202 min read
Power BI Buttons - Page Navigation with Icons
I find buttons to have a variety of uses in Power BI! This button technique shows you how to add an icon based button for page navigation...
1,1100
![Careful with RangeEnd with Incremental Refresh](https://static.wixstatic.com/media/991134_529fda26e62f4e6e8ed16d31337a2247~mv2.png/v1/fill/w_292,h_219,fp_0.50_0.50,q_95,enc_auto/991134_529fda26e62f4e6e8ed16d31337a2247~mv2.webp)
DataZoe
Nov 2, 20201 min read
Careful with RangeEnd with Incremental Refresh
Lately I've been working with incremental refresh and found that while RangeStart changes with the settings for incremental refresh the...
2010
![Keep 0 on axis for the positive and negative](https://static.wixstatic.com/media/991134_4facf893518f426b9a750559e728cc75~mv2.png/v1/fill/w_292,h_219,fp_0.50_0.50,q_95,enc_auto/991134_4facf893518f426b9a750559e728cc75~mv2.webp)
DataZoe
Oct 30, 20201 min read
Keep 0 on axis for the positive and negative
Add a constant line to a line chat to always have 0 on the axis.
650
![Power BI Visual Guide (In Power BI)](https://static.wixstatic.com/media/991134_1e7f02af48b54a67bb9b3e4ff0c645a7~mv2.png/v1/fill/w_292,h_219,fp_0.50_0.50,q_95,enc_auto/991134_1e7f02af48b54a67bb9b3e4ff0c645a7~mv2.webp)
DataZoe
Oct 28, 20201 min read
Power BI Visual Guide (In Power BI)
I've seen amazing data visualization guides but here is one showing them all in Power BI! The idea is to see different types of charts...
3990
![DateID compare to DateTime in Power Query for Incremental Refresh](https://static.wixstatic.com/media/991134_1b2f9154f00c4b11bade5bcc8183ac8f~mv2.png/v1/fill/w_292,h_219,fp_0.50_0.50,q_95,enc_auto/991134_1b2f9154f00c4b11bade5bcc8183ac8f~mv2.webp)
DataZoe
Oct 27, 20201 min read
DateID compare to DateTime in Power Query for Incremental Refresh
Incremental refresh requires a DateTime field and many tables come from the database instead with the DateID column. Here is how to...
1780
![Power BI Challenge #8 at Enterprise DNA](https://static.wixstatic.com/media/991134_1277c58f8f7c4d60aea301ec68602489~mv2.png/v1/fill/w_292,h_219,fp_0.50_0.50,q_95,enc_auto/991134_1277c58f8f7c4d60aea301ec68602489~mv2.webp)
DataZoe
Oct 26, 20201 min read
Power BI Challenge #8 at Enterprise DNA
I've been participating in the Enterprise DNA Power BI Challenges, in which I am enjoying being as creative as I want. When developing...
4260
bottom of page