Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Solved! Go to 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
What are you trying to do? I only see 1 visual
Fetching the selected value. In the example "Denemark"
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
Great solution, It worked for me as well.
Thank you !
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
96 | |
77 | |
66 | |
53 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |