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
emmasd
Regular Visitor

parameter not interacting with my visuals

Hello,

 

I need the parameter to manually enter values, then I need the table to display the values higher than what I entered in the parameter, but it is not working and not interacting with the visuals.

 

my actual purpose is to manually enter a value and if that value is higher than the average, then the symbols with a p/b ratio higher than the entered value should be displayed, I thought the parameter is the best way of action, but currently not working?

I would appreciate any advice!

emmasd_0-1721306416838.png

 

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Hi @emmasd ,

 

In fact, for your problem, you can directly use slicer for the data that needs to be filtered, and switching the slicer style can also realize it. Following the way you want, I made simple samples, you can check the result as below:

vtianyichmsft_0-1721357148937.png

vtianyichmsft_1-1721357160370.png

 

An attachment for your reference. Hope it helps!

 

Best regards,
Community Support Team_ Scott Chang

 

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

 

 

View solution in original post

2 REPLIES 2
Anonymous
Not applicable

Hi @emmasd ,

 

In fact, for your problem, you can directly use slicer for the data that needs to be filtered, and switching the slicer style can also realize it. Following the way you want, I made simple samples, you can check the result as below:

vtianyichmsft_0-1721357148937.png

vtianyichmsft_1-1721357160370.png

 

An attachment for your reference. Hope it helps!

 

Best regards,
Community Support Team_ Scott Chang

 

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

 

 

amitchandak
Super User
Super User

@emmasd , if you have created this using Parameter (Numeric) or generateseries and noy joined with table, it will not filter

 

You need to have measure like below, with all groupby of visual 

 

Sumx(Filter(Summarize(Table, Table[Column]) , [Your measure] <[Selected value of Param] ) , [Your Measure])

 

https://docs.microsoft.com/en-us/power-bi/desktop-what-if

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

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

August 2025 community update carousel

Fabric Community Update - August 2025

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