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

Fetching the selected value. In the example "Denemark"

TomMartens's avatar
TomMartens
Super User
7 years ago

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

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

      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'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.