Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

More than one hierarchical level in same chart

I have a bussiness requriement that the user should be able to compare three levels of hierachical data in the same chart.

 

Our data is collected on hospital level, summed up to regional level and then lastly summed on a national level. This is what our chart looks like in SSRS. The bars that are not labeld as either regional or nation is on hopital level.

 

 

Is this chart possible to duplicate in Power BI?

 

The data is gouped on hopital level in our SQL Server database, but I can easily write SQL to group them in other ways.

 

One more requirement is that we would like to filter (slice) the chart on regional and hospital level.

Need Help

2 Replies

  • v-frfei-msft's avatar
    v-frfei-msft
    Icon for Community Support rankCommunity Support
    8 years ago

    Hi Anonymous,

     

    Based on my test, we cannot put more than one hierarchical level in same chart. However, we can dill up/down in the hierarchical to view different data. By the way, You can come up a new idea to Power BI ideas and add your comments there to improve Power BI and make this feature coming sooner.

     

     

    Regards,

    Frank

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      Thanks, this is what I have found when testing as well. I will have to create some kind of workaround which will be more or less messy.

       

      It would be great if the drill down feature had the ability to leave the bar for the higher level(s) in the chart for comparison. A bit like breadcrumbs. The bar could slide to the left and stay in an area highlighted for top level bars. I will post in ideas.