Report with double rows on column header

[pedroccamara]

Hey guys,
I didn’t know how to call this kind of visual behind.

I’m interested on how to do those in blue. I’ve looked for it everywhere and didn’t find it.
Anyone can help?
Thanks a lot
Pedro

[Harsh]

Hello @pedroccamara,

Thank You for posting your query onto the Forum.

is this the kind of result you’re looking? Below is the screenshot provided for the reference -

It’s just I haven’t formatted my heading since I’d created this file just to provide the solution onto the Forum.

I’m also attaching the working of the PBIX file for the reference. Alongwith the solution post (For reference - just in case).

Hoping you find this useful and meets your requirements that you’re looking for.

Thanks and Warm Regards,
Harsh

SampleData.pbix (71.3 KB)

Grouping Measures in Matrix Table

Hello @Max Lastly after several hours of head scratching I was able to group your measures under the same category. And this is the only way around that this type of result could be achieved due to the asymmetrical nature of the data. Because we’ve 3 measures for the “Revenues” but only single measure for the “Users”. Now, since we’d “Product”, “Attribute” and “Scenario” into the rows section and the “Month” in the columns section we’re not able to club these measures and therefore we’d…

[pedroccamara]

Awesome @Harsh. That’s exactly it!
Thank you so much!!!

[Harsh]

Hello @pedroccamara,

You’re Welcome.

I’m glad I was able to help you.

Thanks and Warm Regards,
Harsh

[pedroccamara]

Hey @Harsh,
Sorry to disturb you again on this subject but, after all, i don’t think this solution is what i was looking for just because i have only one row and 4 columns/measures, like Sales, sales Ly, Sales Diff and Sales %.
Could there be another way of doing this?
Thanks
Pedro

[Harsh]

Hello @pedroccamara,

Does this type of solution satisfies the requirement that you’re looking for? Below is the screenshot provided for the reference -

Have tried to implicate the scenario that you’re trying to achieve.

Also attaching the working of PBIX file for the reference

Hoping you find this useful.

“Sorry to disturb you again on this subject” - No worries, always happy to help.

Thanks and Warm Regards,
Harsh

Report with double rows on column header.pbix (494.8 KB)

[pedroccamara]

Yes! That’s it!
I believe the first solution you have to unpivot, but with this one, just a simple matrix. I’m so embarrassed @Harsh.
Thank you so much. You’ve been a great help!
Best regards
Pedro

[Harsh]

Hello @pedroccamara,

You’re Welcome.

I’m glad I was able to help you again.

Well in the first case also I tried the same thing. It was actually the asymmetrical nature of the data where I just had to flip fields from rows to the columns and columns to the rows to avoid as many blank rows as possible.

“I’m so embarrassed” - Absolutely no need to be. We all learn something new when questions are being asked by the members. All questions are of equal importance so ask your questions freely we’ll always be there to answer it happily and wholeheartedly.

Thanks and Warm Regards,
Harsh