Multiple Header Column with Live Connection

[rolitos]

Hi,

I'm using Power BI in order to replicate a Performance Board (nowadays only on a physical board).

The board looks like this:

Is it possible to merge the column "Daily evolution" above the day names and keep the other KPIs outside the day names? All data comes from Live Connection, even the day names.

Since I'm using a live connection, thus I cannot modify data in the edit queries section, like I read in other similar posts.

Can someone help me? 🙂

Thanks!

[tkirilov]

Hi @rolitos ,

It's rather difficult to answer this without knowing what the actual data looks like, but an idea might be to use several card visuals to display the different components of this table and then colour code these to achieve the same effect. Hope this helps.

Best,

Tom

[rolitos]

Hi @tkirilov ,

An example of data in the board:

The variable "names" and "week day" are string variables. Furthermore, I want to have values in the KPIs (VoC, TMC, Detractors, Audit, HIT Ration, Rep), which are numeric variables.

Does still your suggestion works with the inputs above?

Thanks,

R

[tkirilov]

So if the KPIs titles do not change with time, then you could have those in card visuals and the rest (names and dates) in a table below those.

You could also try to transpose those in a Matrix visual. You can have KPIs and dates as rows and Names as columns.