Forum Discussion

waltonb's avatar
waltonb
Frequent Visitor
9 years ago

Determine Axis Values based on Cursor Position

Hello,   When you have a time based chart, PowerBI displays the value of both X & Y axis values depending on the relative position of the cursor over the chart.   Refer image below, which shows t...
Need Help
v-sihou-msft's avatar
v-sihou-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

waltonb

 

I can't see the image. Can you re-upload it?

 

Regards,

  • waltonb's avatar
    waltonb
    Frequent Visitor
    9 years ago

    ...image re-uploaded as requested...

     

    Cheers.

    • v-sihou-msft's avatar
      v-sihou-msft
      Icon for Microsoft Employee rankMicrosoft Employee
      9 years ago

      waltonb

       

      Currenly, it's not supported to get the values based on mouse hover position. You must the select (which means you need to click) so that the selected value can be taken by DAX formula into filter context.

       

      Regards,

      • waltonb's avatar
        waltonb
        Frequent Visitor
        9 years ago

        Hi Simon,

         

        What I'm hoping to be able to do is:

        1. click on chart
        2. click on relevant month within chart
        3. have DAX formula  determine which date was clicked on by the user

        Are you able to provide me with the DAX formula that will allow me determine the selected value from a click within a chart??

         

        I've already developed DAX code for extracting filter values and then using them for dynamic lookups...

         

        Cheers.

         

        Braden.