Dynamic Slicer

[Anonymous]

Hi there,

I have a column called 'total hours' in a data set and what i need is a dynamic slicer / selector which will determine which individuals are to be included based on what is selected. The second thing i think i will need is a column ('selection include') which calculates who is to be included based on the selection.

For example the slicer would be something like '100+', '200+', '300+'. If '100+' was selected then the 'selection include' column would calculate all the individuals with 100+ hours which could then be used in a visual.

Is this possible and how do i set this up?

[Jihwan_Kim · Accepted solution]

Hi, @Anonymous 

Please check the below picture and the sample pbix file's link down below, whether it is what you are looking for.

All measures are in the sample pbix file, and the steps are numbered in front of each measure.

https://www.dropbox.com/s/ttdn0prp4sijd9w/petecart.pbix?dl=0 

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

Linkedin: https://www.linkedin.com/in/jihwankim1975/

[Anonymous]

Thanks Jihwan, this is exactly what i need. Much appreciated!