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.