Forum Discussion

gbraga's avatar
gbraga
New Member
3 years ago

Get id from Slicer Name

I have a dimensional table that has names and project ids.

I would like to use a slicer as a filter for a query that only has project_id so I need to get the id selected in the slicer, but the slicer must contain the project name for readability/ease of use.

How can I get the project id from the name on the slicer?

General Comment
Need Help

1 Reply

  • Mahesh0016's avatar
    Mahesh0016
    Super User
    3 years ago

    gbraga I hope it helps you. Thank You!!
    Create Measure using SELECTEDVALUE and plot in the card.
    NOTE : when you select Project id from slicer you get that id in card other wise card display blank.

    ID = SELECTEDVALUE('Table'[Project ID])