Power BI Date Hierarchies

Mike Essen points out an issue you can run into with date hierarchies in Power BI:

As you can see, we get the 4 columns of 2016, with a very small Q1, rising through until Q4 is by far the largest value.

This works exactly as I would expect it to, however when I expand down a level my results don’t show as I would expect.

Click through for Mike’s solution.

Related Posts

Disambiguating “App” In Power BI

Melissa Coates gives us the different forms of what an “app” is in the Power BI world: Let’s say you just heard someone mention a Power BI app. What exactly do they mean by that? Well, it depends. The term “app” is used kind of a lot in the Power BI world. So, here’s a […]

Read More

Playing Blackjack With Power BI

Phillip Seamark goes and creates a blackjack game in Power BI: The last of the three data-tables in the model used to control Player 1 is the ‘P1 Turn’ data-table.  This is simply a 10-row single column table with numbers 1 through 10.  The purpose of this table is to use in conjunction with a slicer […]

Read More

Categories

April 2017
MTWTFSS
« Mar May »
 12
3456789
10111213141516
17181920212223
24252627282930