Add control for a group filter

Q&A
, , , ,
1

Hi Team,

I have a group filter which is either company name or their id. Is there any way that I can add a control to include both name and id information in the dropdown list to choose from in the control panel?

Thanks in advance.

2

Hi @mmmzzss,
In this instance, are company name and ID separate fields in your dataset? You can create a calculated field using the concat function to bring in both company name and ID, it would something like this:

concat(
    ifelse(
        isNull({Customer ID}),
    '',
    toString({Customer ID})
    ),
    ' ',
    ifelse(
        isNull(Customer),
    '',
    Customer
    )
)

Then use this calculated field to create a filter control on your visual. In the drop down, your options should bring in both company name and ID.

Let me know if you have any additional questions or if this helps with your solution.

Thank you!

3

It perfectly works! Thanks Brett

1 Like
4

Yes they are two separate fields in the dataset -
Is it possible to add company name and id controls at the same time? Like when I choose one of them say as Google Inc,. , the other one is automatically changed to google.

6

Hi @mmmzzss,
I’m glad this worked for you!

In regards to your follow up question, yes this can be achieved through Parameter based controls. If you setup each as a parameter and create a control, you can have them link to each other to only show relevant values.
To accomplish this; click on the elipses of the control and select ‘Edit’. In the Format section that opens up, expand the ‘Control Options’ portion and select ‘Show Relevant Values Only’.

image
image277×707 26 KB

Select the other control you’d like to have it react to and you should be all set!