Matrix Visual: Show values in separate clusters instead of together for each column

Power BI Data Model
1

In an excel pivot, this is doable like shown below.

image
image.png1854×570 85.4 KB

In Power BI matrix, I am only able to have it like shown below. Is there a way to show it where Exp for Q1-Q4 are altogether followed by 2018 total, then followed by YoY Chg for Q1-Q4 altogether then 2018 total, then lastly, followed by YoY Chg% for Q1-Q4 and then 2018 total?

image
image.png1411×354 93.6 KB

Regards,

Ferdinand

2

It’s quite interesting.

I’m actually not sure you can do it exactly like that right now.

I’ve done some testing myself and couldn’t get to that exact look.

You can change a number of things here

image
image.png296×540 11.2 KB

I got it to look like this

image
image.png866×566 38.7 KB

But this was the closest I got.

See if there’s any combination of things you can do in the formatting area

3

Thanks Sam! I think showing the measures as rows might be a good alternative. My manager might like it.

Best regards,

Ferdinand