Slicer to filter several columns by name

[Anonymous]

Hello everyone!

I stumbled apon an issue, and I don't seem able to find a solution for this, hope someone can help (I'm not sure this can be done).

So let's assume I have a table like this:

Date	Store 1 NPS	Store 1 Sales	Store 1 Volume	Store 2 NPS	Store 2 Sales	Store 2 Volume
02/01/2021	100	1000	13445	30	29874	625431
03/01/2021	30	2978742	555	50	3876	86423
04/01/2021	40	34764324	303947	100	81653	87642
05/01/2021	80	82746	3749992	-90	98632	98654
06/01/2021	30	4726424	8263333	78	87541	875443

And if I have any chart with, for example sales evolution over time, I need to be able to filter it by store, in this case, I need to have a slicer where I am able to choose store 1 or store 2. And to be able to do this in any chart.

Is that possible?

Thank you so much for the help,

[parry2k]

@Anonymous doesn't matter how many columns you have, and specially when it comes and goes, it is more scalable as you don't need to juggle and worry about if there is a column missing or changed. 

Anyhow I will leave it up to you to decide but this is the RIGHT WAY OF DOING THINGS, if you are looking for shortcuts, I hope someone else can help. Good luck!

[parry2k · Accepted solution]

@Anonymous see the attached solution, I did transformation, you can tweak it as you see fit, you can slice it by store or type of your measure.

Check my latest blog post Compare Budgeted Scenarios vs. Actuals 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.⚡

[parry2k]

@Anonymous It is not a great a design from Power BI perspective, you should unpivot your table, bring store 1 and 2 to the rows and that is a best practice and good design and will also get you what you are looking for.

Check my latest blog post Compare Budgeted Scenarios vs. Actuals 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.⚡

[Anonymous]

Hi Parry

It does look like a good solution. But that was a very simplified table, my real table has a lot more columns and variables besides that one, so I don't think that would be a good solution.

Sometimes some columns come and go.

So I don't think that would be a viable solution :s