Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

using parameter values in visual filter

Dear experts

 

I have a requirement. I have defined a parameter named Para in the query editor and applied the same on column C1 , in Table T1.

 

In the dashboard, i have a visual based on Table T2, this table has column C2 which has similar values of Column C1 of Table T1.

I would likt to use the value selected in parametre Para and apply the same filter on Column C2.

I am trying to use VALUES(Parameter[Para]) in the visual filter on Column C2, but its not working. Could anyone help me how to capture the value of a parameter and use the value to filter another column? ANy help will be appriciated.

 

Thanks

Raj

  • parry2k's avatar
    parry2k
    8 years ago

    try this:

     

    add new column :

     

    Filter c2 = if(t2[c2]=Values(para[para]),1,0)

    and in visual filter use where "Filter C2" = 0

6 Replies

  • parry2k's avatar
    parry2k
    Super User
    8 years ago

    why you cannot use the parameter in query editor to filter records in t2 as you did for t1?

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      Thanks for the reply. Since there are other visuals based on T2, i cannot filter at query editor level. Hence looking for way to filter at visual levels.

      • parry2k's avatar
        parry2k
        Super User
        8 years ago

        try this:

         

        1. Turn on Enabled Load on edit queries for parameter.

        2. Add new measure called "filter c2" in your table t2,

        filter c2 = sum(c2) - values(para[para])

        , assuming para is a number parameter and c2 is number column as well.

        3. Add "filter c2" measue to visual filter and chooise the filter condition, like "Filter C2" is greate than 0