Forum Discussion

MadMarc's avatar
MadMarc
New Member
9 years ago
Solved

Display grouped data and detailed values on the same chart

Hi,   In Excel we are used to present our KPIs charts with the following canvas : Averages by year from 2010, then Averages by week for current year, then Average of current year, then future objec...
  • Anonymous's avatar
    Anonymous
    9 years ago

    Hi MadMarc,

     

    Current power bi not support to display main hierarchy level and drill down its child data at the same visual level.

     

    For your requirement, you can refer to below steps:

    1. Summary year level data to one table, week level to another table.(keep the same sturcture)
    2. Use Union function to merge these tables, then use the merged table as the source of chart.

     

    Regards,

    Xiaoxin Sheng

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi MadMarc,

 

Current power bi not support to display main hierarchy level and drill down its child data at the same visual level.

 

For your requirement, you can refer to below steps:

1. Summary year level data to one table, week level to another table.(keep the same sturcture)
2. Use Union function to merge these tables, then use the merged table as the source of chart.

 

Regards,

Xiaoxin Sheng

MadMarc's avatar
MadMarc
New Member
9 years ago

Hi Anonymous,

 

It's the solution that came into my mind also, it's actually the way we work in the old Excel chart.

 

The downside with this is that we're loosing the 'dynamic' capabilities of Power BI (I.e. drilling down a past year and keep the same layout) but I'm probably too greedy about the young and promising software that is Power BI. We will wait until further releases include this.

 

Thanks.

 

Marc