Conditional axis value based on selected value

Hi ChrisPala 

johnbasha33 Thank you very much for your prompt reply. Allow me to add something here.

Your understanding is correct, the measure really don't work on the axes.

If you can, I recommend that you use another visualization object to display the results.

In order to create a measure, you need a virtual table as a slicer.

virtual table = VALUES('Table'[site name])

Create a measure.

hide site name = 
var _slicer = VALUES('virtual table'[site name])
RETURN
IF(
    ISFILTERED('virtual table'[site name]) && SELECTEDVALUE('Table'[site name]) in _slicer,
    SELECTEDVALUE('Table'[site name]),
    "xxx")

Note that for the site name I created the columns are formatted as text.

Here is the result.

Regards,

Nono Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.