Forum Discussion

shtefanvalery's avatar
shtefanvalery
Frequent Visitor
9 years ago

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

  • shtefanvalery's avatar
    shtefanvalery
    Frequent Visitor

    I've tried ChicletSlicer. It shows the only value i need, but i prefer to use horizontal slicer without "blank".