Filtering from within a parameter fields

[maziiw]

I have a parameter field which looks like this:

param - funnel breakdown = {
    ("Overall", "None", 0),
    ("Top 6 IDs", NAMEOF('Conversion'[Visual Breakdown Top IDs]), 2),
    ("Device Type", NAMEOF('Conversion'[DEVICE_TYPE]), 3)
}

For Device type, in my data i have mobile, tablet, desktop.

i also have other metrics such as overall counts and conversions on the page

How can I filter this parameter so that the split is only for mobile and desktop and does not show tablet? i want tablet to still be included in overall other metrics (such as transactions), but just not seen on the split.

Thanks for your help!  

[v-karpurapud]

Hi @maziiw 

We have not received a response from you regarding the query and were following up to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions.

Thank You.

[v-karpurapud]

Hi @maziiw 

I would also take a moment to thank  @PhilipTreacy  and @dinesh_7780  for actively participating in the community forum and for the solutions you’ve been sharing in the community forum. 

I hope the information provided help you fix the issue. If you still have any questions or need more help, feel free to reach out. We’re always here to support you 

Best Regards, 
Community Support Team  

[dinesh_7780 · Accepted solution]

Hi @maziiw ,

Follow below steps.

1. Create a calculated column that keeps only Mobile and Desktop, and marks everything else as “Exclude”.

Device Type Filtered =

IF (

    'Conversion'[DEVICE_TYPE] IN {"Mobile", "Desktop"},

    'Conversion'[DEVICE_TYPE],

    BLANK() 

)

Note: Use BLANK() if you want Tablet to simply not appear in the visual.

2.  Change your parameter tuple for Device Type.

param - funnel breakdown = {

    ("Overall", "None", 0),

    ("Top 6 IDs", NAMEOF('Conversion'[Visual Breakdown Top IDs]), 2),

    ("Device Type", NAMEOF('Conversion'[Device Type Filtered]), 3)

}

Now when Device Type is selected, Only Mobile and Desktop appear. Tablet still exists in your model and is included in Overall metrics, conversions, etc.

If my response as resolved your issue please mark it as solution and give kudos.

[PhilipTreacy]

Hi @maziiw 

You need to write a bit of DAX, first to detect when Device Type is selected

Is Device Type Selected = SELECTEDVALUE('param - funnel breakdown'[Order]) = 3

Then write a measure that tells you when the Device Type is either mobile or desktop

Device Filter =

IF( 
    [Is Device Type Selected],
    'Conversion'[DEVICE_TYPE] IN {"mobile", "desktop"},
    TRUE()
)

Then on the visual where you show the parameter split, use that measure as a filter.

Regards

Phil