cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
abukapsoun
Helper V
Helper V

User Input for filtering

Hi,

 

I believe it is not possible but I am just trying my luck. I have a visual that is displaying results based on the visual level filters. Displaying values that are less than "5"

 

Is there a way, where I can create a visual where I can input the value I want to use in the filter instead of doing it on the visualization tab?

 

In other words, I want to give the option for users who are seeing the report to be able to filter based on custom value instead of a pre-defined one. 

 

thanks,

 

1 ACCEPTED SOLUTION
Eric_Zhang
Microsoft
Microsoft


@abukapsoun wrote:

Hi,

 

I believe it is not possible but I am just trying my luck. I have a visual that is displaying results based on the visual level filters. Displaying values that are less than "5"

 

Is there a way, where I can create a visual where I can input the value I want to use in the filter instead of doing it on the visualization tab?

 

In other words, I want to give the option for users who are seeing the report to be able to filter based on custom value instead of a pre-defined one. 

 

thanks,

 


@abukapsoun

Instead of applying visual level filter, you can create a what if parameter and control the data presentence with a tricky measure like

isShown =
IF (
    SUM ( Table1[Column2] ) <= Parameter[Parameter Value]
        || ISBLANK ( Parameter[Parameter Value] ),
    SUM ( Table1[Column2] ),
    BLANK ()
)

whatif.gif

 

View solution in original post

2 REPLIES 2
Eric_Zhang
Microsoft
Microsoft


@abukapsoun wrote:

Hi,

 

I believe it is not possible but I am just trying my luck. I have a visual that is displaying results based on the visual level filters. Displaying values that are less than "5"

 

Is there a way, where I can create a visual where I can input the value I want to use in the filter instead of doing it on the visualization tab?

 

In other words, I want to give the option for users who are seeing the report to be able to filter based on custom value instead of a pre-defined one. 

 

thanks,

 


@abukapsoun

Instead of applying visual level filter, you can create a what if parameter and control the data presentence with a tricky measure like

isShown =
IF (
    SUM ( Table1[Column2] ) <= Parameter[Parameter Value]
        || ISBLANK ( Parameter[Parameter Value] ),
    SUM ( Table1[Column2] ),
    BLANK ()
)

whatif.gif

 

View solution in original post

WolfBiber
Microsoft
Microsoft

Hey,

I think you can't reach this goal with onboard visual.

But try i.e. "Text Filter" in Custom VisualsUnbenannt.png

Greetings,

Wolf

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

Top Solution Authors
Top Kudoed Authors