Forum Discussion

flo3o's avatar
flo3o
Frequent Visitor
1 year ago
Solved

Get value from two data slicer which use the same column

Hello,   I want to get the value from two data slicers, which are using the same column (so I can not use selectedvalue). How can I do that? For a little context with the first data slicer the user...
  • shafiz_p's avatar
    1 year ago

    Hi flo3o  I think this is not possible to capture different value from 2 different slicer of the same column. To achieve this you need 2 disconnected table with single column. 

    If you want this, create 2 disconnect table using the same columne. For example:

    StartActivityTable = DISTINCT('YourTable'[Activity])
    EndActivityTable = DISTINCT('YourTable'[Activity])

     

    Then create 2 different measure to capture Start and End activity. For example:

    SelectedStartActivity = SELECTEDVALUE('StartActivityTable'[Activity])
    SelectedEndActivity = SELECTEDVALUE('EndActivityTable'[Activity])

     

    Now you can use this 2 measure to your calculation to calculate the lead time between them.


    Hope this helps!!

    If this solved your problem, please accept it as a solution and a kudos!!

     

    Best Regards,
    Shahariar Hafiz