Hierarchy In powerBi service

Help Me out

In a dashboard are there many reports out off all, some reports are under one category and some other like parent and child category

Ex:Energy
1.Electricity

2.Fuel
3.Water

when we publish the reports in powerBi service The reports are selcted based on above category. If any one knows pls let me know

Hi Chinna Kanchireddy,

You can create a hierarchy of reports within a dashboard by organizing them under different categories. This allows for better organization and navigation within the dashboard.

For example, let's consider a scenario where we have a dashboard related to energy consumption. Under the category "Energy," we can have subcategories such as "Electricity," "Fuel," and "Water." Each of these subcategories can further contain specific reports related to their respective topics.

When you publish the reports in Power BI Service, you can select the appropriate category for each report. This helps in organizing and grouping similar reports, making it easier for users to find and access the information they need.

By utilizing the hierarchy feature in Power BI Service, you can create a structured and organized dashboard that allows users to navigate through different categories and subcategories, providing a seamless and intuitive user experience.

Here's an example of how you can create a hierarchy in Power BI Service :

Hierarchy = 
    PATH("Energy", "Electricity")
    & PATH("Energy", "Fuel")
    & PATH("Energy", "Water")

By defining the hierarchy using the PATH function, you can establish the relationship between the different categories and subcategories in your reports.

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Jayraj Chhaya2y ago
Accepted answer
Hi Chinna Kanchireddy,

You can create a hierarchy of reports within a dashboard by organizing them under different categories. This allows for better organization and navigation within the dashboard.

For example, let's consider a scenario where we have a dashboard related to energy consumption. Under the category "Energy," we can have subcategories such as "Electricity," "Fuel," and "Water." Each of these subcategories can further contain specific reports related to their respective topics.

When you publish the reports in Power BI Service, you can select the appropriate category for each report. This helps in organizing and grouping similar reports, making it easier for users to find and access the information they need.

By utilizing the hierarchy feature in Power BI Service, you can create a structured and organized dashboard that allows users to navigate through different categories and subcategories, providing a seamless and intuitive user experience.

Here's an example of how you can create a hierarchy in Power BI Service :
```
Hierarchy = 
    PATH("Energy", "Electricity")
    & PATH("Energy", "Fuel")
    & PATH("Energy", "Water")
```
By defining the hierarchy using the PATH function, you can establish the relationship between the different categories and subcategories in your reports.