Forum Discussion
Helper IICreate Slicer for Multiple Columns
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.
Helper IIThank you for your reply. I was going to try to Unpivot the columns, however, the fields that I'm working with are calcualted columns and therefore I'm unable to Unpivot these columns. I apologize that i negelected to mention this in the original post. I had to bring the data into this table from another Power BI (Direct Connection) and therefore I needed to create calculated columns for this data.
Any thoughts on how this can be accomplished with calculated columns? I attempted to Concanate the columns however, since it's possible that a rep could have completed more than one course this does not allow one occurance of each course (some may have two or three courses).
- ss8551
sorry some reps may show 2 or 3 courses and therefore concatenation will not provide a unique value for each course.
- ss8551
Any thoughts since this cannot be unpivoted how to accomplish this?
- ss8551
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.