Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Anonymous
Not applicable

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

1 ACCEPTED SOLUTION

try this:

 

add new column :

 

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

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



Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤


Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

View solution in original post

6 REPLIES 6
parry2k
Super User
Super User

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



Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤


Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

Anonymous
Not applicable

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.

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

 

 



Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤


Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

Anonymous
Not applicable

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



Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤


Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

Anonymous
Not applicable

Thank you Parry2k, this works.

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Top Solution Authors