SELECTEDVALUE not working

[Yuval_Marnin]

Hi,

I trying to use SELECTEDVALUE function and it is not returning any value after I filter the reoprt when pressing one bar at Bar chart.

my syntex is very simple:

test = SELECTEDVALUE(Y2017[Country])

any ideas what am I doing wrong?

[MattAllington]

What are you trying to do?  I only see 1 visual

[Yuval_Marnin]

Fetching the selected value. In the example "Denemark"

[TomMartens]

Hey,

I created a measure like you did to capture the selection of the axis value:

GetSelected Sales Territory = SELECTEDVALUE('Dimension City'[Sales Territory])

I assigned the measure to a card visual, as you can see from the gif below, it works as expected, so as @MattAllington asked, please describe in more detail your expected result.

A card visual is above the column chart that is captures the selected sales territory, and goes blank if no axis value is selected.

Regards,

Tom

[Yuval_Marnin]

@TomMartens  @MattAllington 
Thanks for the replay.

I did exactly like you demonstared.

I have a textbox title assiged to the column by using title text and than fx. 

I assigend it by using the column name ("test" in my case) and "first" summerarzion. and still nothing.

I even look at the Data columns after selecting the Country and the columns seem to be black too.  

[TomMartens]

Hey @Yuval_Marnin ,

please create a pbix, that allows to recreated the issue, upload the file to onedrive or dropbox and share the link.

Regards,

Tom

[Yuval_Marnin]

@TomMartens 

I uploaded the file to one drive.

here is the link

https://1drv.ms/u/s!Apvu9B7DB5Mng0KUCWm8bAJpmkk9

I deleted all the unneccery columns to make it simple.

The title of the text box and the bar chart should be change when choosing the country.

I am sure it is simple mistake I made but I just can't find it.

[TomMartens · Accepted solution]

Hey,

the measure Measure looks like this:

Measure = SELECTEDVALUE(Y2017[Country])

Assigning the this measure to title of the text box like so:

Creates a report like this:

Unfortunately the title will of the chart itself will not be updated, not sure if this is a bug or by design. Maybe you want to create an issue.

Regards,

Tom

[Yuval_Marnin]

Great solution, It worked for me as well.

Thank you !

[MattAllington]

Where are you expecting to see the selected value?  I only see one visual - the one you are selecting. Please explain exactly what you expect to see.