Showing multiple measures in columns but not alternativly.

[hatahetahmad]

Hello to all you good people.

So I have a matrix with drill down showing this year measure, and I have one for last year. 

In my columns under companies names I put the current year measure, then when I add last year each company has two columns with each measure.

Can I show them like all companies under them current year values, then another set of the companies with last year values?

I tried:

1. convert columns to rows (Not my goal to show values in rows)

2. Add manual measure table contains measures names, then add the measures name as column above company names (didn't work either)

Showed like this:

                 YTD                             YTD LY

       com1    |    com2     ||     com1   |    com2

   YTD     LY   YTD     LY   YTD     LY   YTD     LY

I want like this

       com1    |    com2     ||     com1   |    com2

                 YTD                            YTD LY

3. I searched for custom visual but no luck.

Any Ideas 🙂

[mahoneypat]

One idea is to just use two adjacent matrices (one for each measure with company as columns), and change the format/settings of the one of the right to make it appear like it's one table.  Haven't tried it so not sure how well that would work out, but worth trying.

Regards,

Pat

[hatahetahmad]

Unfortunately, It'd work if there is no drill down, But if we can sync the two tables I believe it'd work.

[v-lili6-msft]

hi  @hatahetahmad 

To my knowledge, It could not achieve in power bi for now.

If you want to use this workaround, you need to drill down two visual separately.

Regards,

Lin