Toggle Options for selection

[shakeelsyed]

Hi, 

I am trying to achieve something which is very dynamic and on a special request from my client.

I am using dropdown slicer to filter out un-wanted data(exceptions) from raw data and there I am having a "Product" column which has single value and other rows are in that column are blank, now my client want to see only product that is there in the column and if the prodcut is selected then it should show product details else if unchecked then it should show all the data in the table.

below screenshot defines the requirement clearly, there is a slier called "YBL Group" and in there is a product called "SHG" and othere rows are showing blank in that slicer, now client want to see only product with check option and if its uncheck then it should show the entire details and if I use page level filters to remove blank values then my entire report is having only "SHG" Product details in it, I have taken a similar screenshot from power bi communicty website.

can anyone help me on this.??

Regards,

Shakeel

[v-yuta-msft]

@shakeelsyed,

Hierarchy slicer may meet your requirement, please refer to: https://appsource.microsoft.com/en-us/product/power-bi-visuals/WA104380820?tab=Overview.

  

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[shakeelsyed]

@v-yuta-msft

Thank you very much for your reply,

It is prety much close but I need something like shown in attached when checkbox is checked that particular action should take place else it should be blank.

In the attached sample "Email" Checkbox is active means it will send the email or show data of replies whenever happened and if unchecked then it will not show any data/mail.

is this possible in power bi ?

Regards,

Shakeel

[v-yuta-msft · Accepted solution]

@shakeelsyed,

---

It is prety much close but I need something like shown in attached when checkbox is checked that particular action should take place else it should be blank.

In the attached sample "Email" Checkbox is active means it will send the email or show data of replies whenever happened and if unchecked then it will not show any data/mail.

is this possible in power bi ?

---

I'm afraid currently power bi doesn't support this kind of feature. You may submit your idea here.

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.