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

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

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
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors
Top Kudoed Authors