Changing a column used in a slicer based on another slicer selection

[cdcphist]

Hi,

I'm trying to do the following. I've loaded a table with 1 field and 2 rows:

Type of interval

----------

Multiple

Single

I already have another slicer that references a column. What i want is for this second slicer to reference another column, based on the selection of "Type of interval". I've tried using a switch with selectedvalue function but this only enables me to return a measure and what i want is the column.

Thanks.

[Icey]

Hi @cdcphist ,

Could what @parry2k provided solve your problem?

If it could, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.

If not, please share me a concrete example and I'll test for you.

Best Regards,

Icey

[parry2k]

@cdcphist check this post, I hope it helps.

Check my latest blog post Improve UX: Show Year in Legend When Using Time Intelligence Measures | PeryTUS IT Solutions  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]

@cdcphist unfortunately you cannot do this, either you have to use a bookmark or some conditional formatting to hide one slicer and bring another slicer.

You can use the technique of hiding or making slicer visible from my blog post here.

Check my latest blog post Improve UX: Show Year in Legend When Using Time Intelligence Measures | PeryTUS IT Solutions  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.⚡

[cdcphist]

How can i use a bookmark to hide a slicer?