Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
My Matrix has the following: Columns: Year, Quarter Values: Sales, Contribution Margin
Is it possible to 'pin' certain columns so they are always visible in a matrix, and allow users to filter the rest of the columns?
e.g. I have the following columns: 2019Actuals, 2020Actuals, 2021Actuals, YoY%
I want YoY% to always be visible, and allow a user to select using a slicer which of the other columns they want to see/not see., but YoY% must always stay visible
Is it possible to acheive this?
Hi,
As of I my knowledge, such functionality is not available by default,
may be we can split fact tables into two ways and give similar relationship in data model and write dax to combine both models,
like sum(first tbale values)+sum(second table values).
may be this will work
Hi @fa82 ,
Could you show us your table? Are these columns actual columns in your table? Do you want to add 2019Actuals, 2020Actuals, 2021Actuals, YoY% columns in Matrix? If you want to do this, as parry2k mentioned, Power BI doesn't support us to select column headers directly. I suggest you to create a dim column header table by dax.
Like:
Dim = {"2019Actuals","2020Actuals","2021Actuals"}
Then create measures as below.
2019Actual = If("2019Actual" in Values(Dim[Value]),sum(Table[2019Actual]),blank())
Add YoY% column in Matrix and add measures in matrix.
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@fa82 unfortunately that is not possible at this point. I'm sure there is an idea for this on the ideas forum, do upvote for it.
✨ Follow us on LinkedIn
Learn about conditional formatting at Microsoft Reactor
My latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
97 | |
96 | |
81 | |
74 | |
66 |
User | Count |
---|---|
129 | |
106 | |
106 | |
86 | |
72 |