Forum Discussion
Show / hide values by one element slicer
Hello, community.
I'm new to PowerBi, so maybe most of you will find my question easy.
I've got a report, based on TaskManagement system in Sharepoint. Every task has a few statuses: active1, active2, active3, closed1, closed2. I have stacked bar chart, which shows tasks by department (drilldown to person) in all statuses by default.
I need my report showing tasks in active statuses by default and an option (slicer, i think) "Show all (active+closed)". I thought it would be easy: create a table, then make 2 groups of statuses "all" and "active" or maybe one table with only "active group" and make a slicer, but it didn't worked. I was really close to reach my goal, with one "active group", but a slicer shows the name of my group and a blank value, which is needless.
Maybe I'm on the wrong way? What do you think?
Thank you!
1 Reply
- shtefanvaleryFrequent Visitor
I've tried ChicletSlicer. It shows the only value i need, but i prefer to use horizontal slicer without "blank".