Forum Discussion
Create a slicer based on the dynamic conditional filter
Hi Everyone i am facing a roadblock with the power bi slicer
There's a "Scope" Named column in the table which is added in power bi for report creation. This Columns Contains following information or variables:
1.Never Protected
2.No Longer Protected
3.Protected
4.Protection Not Covered
5.Protection Under Investigation
6.Protection Unknown
I want to Create a column using measures which will contain two Filter option which is mentioned below:
"Incl. patent-protected products"
"Excl. patent-protected products"
this is the sample Data
| Name | Scope | Price |
| A | protected | 254 |
| B | Never Protected | 175 |
| C | No Longer Protected | 295 |
| D | Protection Unknown | 355 |
| E | protected | 450 |
| F | Protection Not Covered | 210 |
| G | Protection Under Investigation | 152 |
this is how the variable looks into the normal slicer in power bi
and I am expecting a result like below:
so the Incl. patent-protected products should contains all the values or variables from Scope column and Excl. patent-protected products should contains all the variables except "Protected"
Can i get an idea how to resolve this ASAP
Hi Dipak_22 ,
Please check that the following results meet your expectations:
An attachment for your reference. Hope it helps!
Best regards,
Community Support Team_ Scott ChangIf this post helps then please consider Accept it as the solution to help the other members find it more quickly.
4 Replies
Hi Dipak_22
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523Hi Dipak_22 ,
I made simple samples and you can check the results as follows
Group = var _s = [Scope] RETURN SWITCH(TRUE(), _s="Never Protected","Excl. patent-protected products", _s="No Longer Protected","Excl. patent-protected products", _s="Protection Not Covered","Excl. patent-protected products", "Incl. patent-protected products")An attachment for your reference. Hope it helps!
Best regards,
Community Support Team_ Scott ChangIf this post helps then please consider Accept it as the solution to help the other members find it more quickly.
Hi Thanks for trying but this is not the solution i am looking for let me rephrase the expecting result as per the pbix you provided
so if under the Incl. patent-protected products have protected, protection unknown and protection under investigationName Scope Sum of Price Group A Protected 254 Incl. patent-protected products D protection unknown 355 Incl. patent-protected products E Protected 450 Incl. patent-protected products G protection under investigation 152 Incl. patent-protected products then under Excl. patent-protected products should have protection unknown and protection under investigation but not protected like this
Name Scope Sum of price Group B protection under investigation 175 Excl. patent-protected products C protection unknown 295 Excl. patent-protected products F protection unknown 210 Excl. patent-protected products please do let me know if this could be possible using something like parameters
Hi Dipak_22 ,
Please check that the following results meet your expectations:
An attachment for your reference. Hope it helps!
Best regards,
Community Support Team_ Scott ChangIf this post helps then please consider Accept it as the solution to help the other members find it more quickly.
