Forum Discussion

TriveniN's avatar
TriveniN
Icon for Helper II rankHelper II
2 years ago
Solved

How to allow users to enter data for slicer

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, bu...
Need Help
  • qqqqqwwwweeerrr's avatar
    qqqqqwwwweeerrr
    2 years ago

    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

     

     

qqqqqwwwweeerrr's avatar
qqqqqwwwweeerrr
Icon for Solution Sage rankSolution Sage
2 years ago

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