O'Reilly logo

Extending Microsoft Dynamics NAV 2016 Cookbook by Alexander Drogin

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Data hierarchies in Power BI reports

In the previous recipe we saw how Power BI creates hierarchies based on date fields, collecting aggregated data on several levels from year to day. Date is not the only possible way to build a scalable report. It is possible to build a hierarchy based on any data, as long as you can provide a link from one level to the next.

How to do it...

In the next recipe, we will create a hierarchy based on geographical data from customer information.

  1. Unfold the list of tables in the database Demo Database NAV (9-0), and select two tables from the list: CRONUS International Ltd_$Customer and CRONUS International Ltd_$Detailed Cust_ Ledg_ Entry. After selecting the tables, click Edit. Table queries will be opened in the query ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required