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

Diagramming Databases With Power BI

Philip Seamark shows how to visualize the relationships between tables using Power BI: The network navigator was another good visual, and if you have an R instance installed on your local machine, you can play with some of the custom R visuals. The catalog views could be used in a similar way to generate power […]

Read More

Web Scraping With Power BI

Imke Feldmann shows how to use Power BI to scrape multiple tables from a webpage: I will present 2 methods here: Append-method: This is the obvious one and is fast for just a few tables. Add-Column-method: A bit more complicated but will be faster for a large number of tables and is also suitable for […]

Read More

Categories

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