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?
Go to Solution.
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.
What are you trying to do? I only see 1 visual
Fetching the selected value. In the example "Denemark"
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.
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.
@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.
I uploaded the file to one drive.
here is the link
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.
Great solution, It worked for me as well.
Thank you !
Engage and empower students with Power BI!
Continue your learning in our online communities.
Travel to Melbourne and network with thousands of peers!
Check out what's new in the Power BI Community!