Forum Discussion
SELECTEDVALUE not working
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
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
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.
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
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.
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