Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe 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.
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 🙂
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
To learn more about Power BI, follow me on Twitter or subscribe 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.
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
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
137 | |
70 | |
64 | |
52 | |
50 |
User | Count |
---|---|
208 | |
91 | |
62 | |
59 | |
56 |