Forum Discussion
Return multiple variables
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.
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
Below is 2 basic example I've quickly thrown together to help clarify.
The 2nd screenshot is the slicer. The left hand slicer (Column1) is how it looks now. The 2nd Slicer to the right Is what I want it to look like. So all 4 values will be grouped into 1 outcome "P1" but all of the data will be retained for all 4 voices.
Once "P1" is selected it the bar chart will display all of the data for all P1 values.
Seanan I already understood, you can do it has i explained above, with the conditional column.
You can give a try to my solution above, but you can have an easier solution.
If the beginning is always the filter that you want to do, you can do it by adding a new column that, for example:
P1 Voice 1 -> you want P1
P1 Voice 2 -> you want P1
P2 Voice 1 -> you want P2
and so on...
In Power Query choose Add Column and select the column that you have the values P1 Voice 1, ...
Select Extract the First Characters:
and input 2, to return only P1, P2, P3 ...
And it will return a new column that you will use in the slicer...
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.