Forum Discussion
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 ...
try this:
add new column :
Filter c2 = if(t2[c2]=Values(para[para]),1,0)
and in visual filter use where "Filter C2" = 0
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
Hi Parry2k,
Thank you. You are close to my requirement. Columns are text.
I would like to use this
values(para[para])
in Column C2 Visual filter. Is there any way to do this?
When i use Values(Para[Para]) in the visual filter its not considering.
try this:
add new column :
Filter c2 = if(t2[c2]=Values(para[para]),1,0)
and in visual filter use where "Filter C2" = 0
Thank you Parry2k, this works.