'Pin' certain columns in a matrix to always be visible regardless of slicer

[fa82]

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?

[Ritheesh]

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

[v-rzhou-msft]

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.

[parry2k]

@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.⚡