Slice by two values

[mb0307]

Hi all,

Eg:  I have rank numbers 1 to 10.  Now I want to add dropdown rank slicer but only allowing users to select any two values between 1 to 10?

If I add two dropdown sliders and allow single selection in each slicer then whatever I select in the slicers1 same selection choice is left in the slicer2.:

Thanks

[parry2k · Accepted solution]

@mb0307 you should create two separate tables for both the slicers and then set it to single selection or turn of edit interactions between slicers. I will go with two seperate tables.

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos 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 · Accepted solution]

The Between slicer will allow you to get two values.  

[dax · Accepted solution]

Hi @mb0307 , 

You could use two tables for two slicers, then use measure to achieve this goal. You could refer to my sample for details.

Best Regards,
Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous · Accepted solution]

The Between slicer will allow you to get two values.  

[mb0307]

@Anonymous  thanks.

I was trying to use the slider but I want user to be able to select only 2 values not whole range.

[parry2k]

@mb0307 can you share the relationship diagram, in fact, you don't need relationship, you can just use the values from the slicer into your measures.

On another note, I liked @Anonymous  idea to create between, and then you can min and max of that slicer which will give you two values. It is neat solution thou.

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos 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]

Combine a couple of the above ideas to use Edit Interactions and the MIN/MAX.  The key with Edit interactions is each slicer has interactions to set as noted by the closed circles.   

HTH,

Smitty

[parry2k · Accepted solution]

@mb0307 you should create two separate tables for both the slicers and then set it to single selection or turn of edit interactions between slicers. I will go with two seperate tables.

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos 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.⚡

[mb0307]

Thanks @parry2k.  I have created the slicer with single selection and built relationship but this filter charts from one slicer (second slicer is ignored).  Checked the interactions as well but still doesn't work.