Forum Discussion

ss8551's avatar
ss8551
Helper II
3 years ago
Solved

Create Slicer for Multiple Columns

Hi,   I have a PBI that has multiple columns and I'm looking for a way to create a slicer that filters based on the values of these columns.  The Rep could appear in multiple columns but i need to ...
Need Help
  • ss8551's avatar
    ss8551
    3 years ago

    If anyone can find a way to resolve this so that the traditional slicer works with multiple calculated columns it would be appreciated.  In the meanwhile i found another visualization as a work around.  not as good a the traditional slicer but it does seem to work for now.  It is the selection slicer by Walnut Innovation.

ss8551's avatar
ss8551
Helper II
3 years ago

sorry some reps may show 2 or 3 courses and therefore concatenation will not provide a unique value for each course.

ss8551's avatar
ss8551
Helper II
3 years ago

Any thoughts since this cannot be unpivoted how to accomplish this?

  • ss8551's avatar
    ss8551
    Helper II
    3 years ago

    If anyone can find a way to resolve this so that the traditional slicer works with multiple calculated columns it would be appreciated.  In the meanwhile i found another visualization as a work around.  not as good a the traditional slicer but it does seem to work for now.  It is the selection slicer by Walnut Innovation.