Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
hatahetahmad
Helper I
Helper I

Showing multiple measures in columns but not alternativly.

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 🙂

3 REPLIES 3
mahoneypat
Microsoft Employee
Microsoft Employee

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

 





Did I answer your question? Mark my post as a solution! Kudos are also appreciated!

To learn more about Power BI, follow me on Twitter or subscribe on YouTube.


@mahoneypa HoosierBI on YouTube


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

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

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.