Forum Discussion
Solved
Return multiple variables
I have list of roughly 126 values, for example P1 Voice1, P1 Voice 2 etc. I'm trying to create a function that will group these values based on a cut off point. I have got the code for grouping ...
No problem, it's just because normally it's easier to help with the pbix file.
From what i understood you what someting like this:
If yes you will need to group the values and use that in the slicer:
If you don't know how to create those bins, you can do it easily in Power Query:
With 126 values it's a little time consuming but it can be done!
Regards,
Sérgio Silva
If this post helps, then please consider Accept it as the solution to help the others find it more quickly.
Apologies I just saw your conditonal formatting column suggestion.
I've altered it a little so that the operator is "Contains" and this has given me the output I'm looking for.
Thank you once again for all your help.
Glad i could help!
Regards,
Sérgio Silva
If this post helps, then please consider Accept it as the solution to help the others find it more quickly.