DataZoe
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...
top of page
Search
DataZoe
- Oct 25, 2021
- 1 min
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...
3080
DataZoe
- Jul 31, 2021
- 2 min
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,453
DataZoe
- Jun 10, 2021
- 4 min
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.
8320
DataZoe
- May 2, 2021
- 2 min
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...
1,8570
DataZoe
- Apr 11, 2021
- 3 min
Buttons to highlight a selected measure!
Use buttons to highlight which selected measure is being used!
1,2810
DataZoe
- Feb 26, 2021
- 4 min
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....
1,5820
DataZoe
- Jan 30, 2021
- 4 min
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
2060
DataZoe
- Dec 20, 2020
- 3 min
Creating a slicer panel!
Many of my reports feature the slicer panel that hide/show on via a button.
8320
DataZoe
- Dec 4, 2020
- 11 min
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....
5800
DataZoe
- Nov 29, 2020
- 2 min
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...
4230
DataZoe
- Nov 2, 2020
- 1 min
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...
1010
DataZoe
- Oct 30, 2020
- 1 min
Keep 0 on axis for the positive and negative
Add a constant line to a line chat to always have 0 on the axis.
400
DataZoe
- Oct 28, 2020
- 1 min
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...
2960
DataZoe
- Oct 27, 2020
- 1 min
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...
1290
DataZoe
- Oct 26, 2020
- 1 min
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...
2740
DataZoe
- Oct 25, 2020
- 1 min
Curved bar chart in Charticulator
Created this with chart to go in my IT Tickets report in https://charticulator.com/. Let me show you how! I followed the tutorial on the...
5320
DataZoe
- Oct 25, 2020
- 1 min
Revision to include spacing
I revised my Sales Executive Dashboard using the fantastic design template from https://www.numerro.io/. I didn't change the charts used...
1410
DataZoe
- Oct 24, 2020
- 1 min
Space Blue Jupiter Windows 10 Desktop Theme
I love space. I am particularly fond of the new blue Jupiter images NASA has up on their Juno mission site. So fond of it, I created a...
880
DataZoe
- Oct 24, 2020
- 1 min
Top/Bottom X On Same Visual Chart
Why have two charts when you can have one? And this one keeps the same scale and context too! Create a chart that shows both top and...
1,0180
bottom of page