Parameter slicer issue

[Vallirajap]

Hii all,
I have a parameter that contains two columns, "Form" and "QcStatus," and I drop the parameter into the slicer. and also assign two more slicers near the slicer in the below image.

Now that I click Form, the nearby silcer displays the Form column values. Then I click QcStatus, and the same slicer displays the QcStatus column value. If I choose the two at the same time, then the slicer is getting an error in the below image.

Now my question is,

When I click on two values in a slicer at the same time, the nearby slicer displays the form value, and another slicer displays the QcStatus value.
How it will happen.

Anyone who knows can tell me the solution,
Thanks in advance!!

[Anonymous]

Hi  @Vallirajap ,

I created some data:

Getting your data revealed that it required permissions, so I created my own:

Here are the steps you can follow：

1. Enter data – create a slicer table.

2. Create measure.

Flag =
var _column1=
NAMEOF('Test'[Form])
var _column_search=
SEARCH("Form",_column1,1,FALSE())
var _column_mid=
MID(
    _column1,_column_search,4)
var _select=SELECTCOLUMNS('Slicer_Table',"select",[Slicer])
return
IF(
    _column_mid in _select,1,0)

Flag2 =
var _column2=
NAMEOF('Test'[QcStatus])
var _column_search=
SEARCH("QcStatus",_column2,1,FALSE())
var _column_mid=
MID(
    _column2,_column_search,8)
var _select=SELECTCOLUMNS('Slicer_Table',"select",[Slicer])
return
IF(
    _column_mid in _select,1,0)

3. Place [Flag] and [Flag2] in the corresponding Slicer's filter, setting is = 1.

4. Result:

Select Form :

Select Form and QcStatus:

Best Regards,

Liu Yang

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

[Vallirajap]

Hi @Anonymous,

Thanks for your reply, and congratulations on your clear presentation. One single change is in the file.

When I click any one of the forms, QcStatus will be shown in the first slicer like a normal slicer, and when I click both of them, at that time the second slicer will be used.

Please guide me to change the single changes.

Thanks in advance!!

[Vallirajap]

Hii @Kishore_KVN,

Any updates about the above use case?

Thanks in advance!

[Kishore_KVN]

Hello @Vallirajap , 

You have to handle this in a different way. 

Step1: create two slicers apart from parameter slicer where first slicer is for FORM and second slicer is for QCSTATUS

Step2: Create a measure like this

Selection = IF(SELECTEDVALUE(Parameter_Column) = "Form",1,2)

Step3: For FORM slicer, add this measure in filters on this visual and set value as 1 and apply it.

Step4: For QCStatus slicer, add the same measure in filters on this visual and set value as 2 and apply it. 

Hope this will fulfill your requirement. 

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

[Vallirajap]

Hi @Kishore_KVN 

Thanks for your reply; your solution guided me to get this type of output.

but my question is when I select the two check boxes. At that time, it will display form in the second slicer and QcStatus in the third slicer.

Is there anyway to do this?

[Kishore_KVN]

I can think of that quickly by looking at your requirement. If you can share a pbix will look into that and can guide you better. Thanks. 

[Vallirajap]

Hii @Kishore_KVN,

Thanks for the help. Below, I share the PBIX file drive link.

Slicer_Demo.pbix 

Thanks in advance!!