Forum Discussion

Yuval_Marnin's avatar
Yuval_Marnin
Frequent Visitor
7 years ago
Solved

SELECTEDVALUE not working

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(Y201...
Need Help
  • TomMartens's avatar
    TomMartens
    7 years ago

    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's avatar
Yuval_Marnin
Frequent Visitor
7 years ago

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's avatar
TomMartens
Super User
7 years ago

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's avatar
    Yuval_Marnin
    Frequent Visitor
    7 years ago

    Great solution, It worked for me as well.

     

    Thank you !