cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
shilpikumari_11 Regular Visitor
Regular Visitor

Key In filter that changes value on Visual

Dear Team,

 

I am having a Visual that has line value which I need to have dynamically based on user input. Currently, I made it as a fixed measure like below. so the 10000 is a calculated measure as "Monthly Target = 10000". now what I want is a filter that a user can key in any value and this line changes based on the key in value, is it possible? let's say if I key in 15000 then it should go as 15000.

Power BI parameter.PNG

 

1 ACCEPTED SOLUTION

Accepted Solutions
adetogni Established Member
Established Member

Re: Key In filter that changes value on Visual

you can have a drop down but you can't allow the user to search for a value, unfortunately. Maybe there are custom visuals taht allow you to do it...

3 REPLIES 3
adetogni Established Member
Established Member

Re: Key In filter that changes value on Visual

Well, "any" value is not easy but

- create a table with all the values you want to show (one row per value)

- put a slicer where you select the value

- then your measure that you show on the line will be "Target=SELECTEDVALUE(yourtable[yourcolumn])

 

The issue is that your table can contain a finite number of values, not "any"

Highlighted
shilpikumari_11 Regular Visitor
Regular Visitor

Re: Key In filter that changes value on Visual

Thnaks, how about if we can have in 000, min 10,000 and max 50000 is it possible , i cannot  have drop down, a user can select 11,000 but with a list how long it can go.

adetogni Established Member
Established Member

Re: Key In filter that changes value on Visual

you can have a drop down but you can't allow the user to search for a value, unfortunately. Maybe there are custom visuals taht allow you to do it...

Helpful resources

Announcements
Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Summit Australia 2019

Summit Australia 2019

Travel to Melbourne and network with thousands of peers!

PBI Community Highlights

PBI Community Highlights

Check out what's new in the Power BI Community!

Top Ideas
Users Online
Currently online: 36 members 954 guests
Please welcome our newest community members: