How to allow users to enter data for slicer

[TriveniN]

Hi ,

I have new requirment and in requirment document they mentioned as user has to provide data for slicers("Occupancy Target (%)")

Note : Normally in slicer , we have an option to select data, but here in this case user has to enter data interms of %.

Below is the formulae for "Total # of Homes"  and "Target Occupancy at month-end"

SELECT COUNT(*) FROM ACQUIR WITH(NOLOCK) WHERE Unit_Status__c NOT IN ( 'disposed', 'Model' )

Target Occupancy at month-end = Total # of Homes * Occupancy Target (%)

when user enter data for Occupancy Target (%) slicer , it will show data for measure "Target Occupancy at month-end" based on user input.

Regards,

Triveni N.

[qqqqqwwwweeerrr · Accepted solution]

Hi @TriveniN 

Here is the solution that you were looking for i have taken random sample data 
As per you SQL Query you have to count all the rows expcet disposed and model hence as per my sample data it should be 5.

Now you need to create decimal paramter for which you folow this setp

and create two measrue first for row conut (total # if homes):

RowCount =

COUNTROWS (

    FILTER (

        'Sheet6',

        'Sheet6'[Unit_Status__c] <> "disposed" && 'Sheet6'[Unit_Status__c] <> "Model"

    )

)
second to multiple by %: 

Measure = [RowCount]*Parameter[Parameter Value] here parameter value is user input. this will give you output somethingh like this 

you can also follow this video for creating paramter: https://youtu.be/O9Be1d_oi6Y

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Check for more interesting solution here: www.youtube.com/@Howtosolveprobem

Regards