big header with value inside

[vadim_g]

hello

often coworker give me excel tables like that :

or better, like this :

The problem is that the specifications (as the minimum or maximum value) is in a big header.

Is there a way to keep the values of the specification for each parameter somewhere in powerbi without copying them on each time line for each parameter ?

Because after i want to do the comparison of the mean value by day and by parameter with the specification.

(Specification value is a number which should not change all the lines, so it is useless to recopy it each time... ?)

Thanks a lot

[Fowmy · Accepted solution]

@vadim_g 

You can keep them in a table using the Enter Data option

[vadim_g]

i understand 😉 i have to have two differents tables.

I prefer to have these two tables automatically without enter by hand the specification table. So i cut my table in two, and it works 😉

Thanks, i accept your answer.