Display grouped data and detailed values on the same chart

[MadMarc]

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 objectives by week. (see example):

Is it possible to achieve this kind of "multi-hierarchy on the same graph" layout in Power BI ?

[v-shex-msft · Accepted solution]

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]

Hi @v-shex-msft,

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

[spuder]

H @MadMarc

it would help to have some sample data for more individual advices.

In general you can define a measure in Power BI that gives you the average of a specific column. This can be drilled from an annual to monthly daily base. Week is a little bit different but I think possible.