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 the X-Axis value(September 2016) and Y-Axis values (0.79 & 1.13*).

 

 

Is there a DAX expression to dynamically identify & hold the X-Axis value (Sept2016) for use in other measures??

 

Is there a DAX expression to dynamically identify & hold the chart "title" (Period & Cumulative MPI) or similar, for use in other measures??

 

I'd like to use the "cursor selected X-axis value" in a dynamic lookup of comments, which would be displayed as part of the tool tip.  That way, as you move along the X-Axis and the cursor position changes, the cursor-X-Axis value also changes, updating the tool tip such that the comments shown is relative to the month the cursor is located over.

 

I'd appreciate any suggestions or recommendations you can provide.

 

Cheers.

6 Replies

    • waltonb's avatar
      waltonb
      Frequent Visitor

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

       

      Cheers.

      • v-sihou-msft's avatar
        v-sihou-msft
        Microsoft Employee

        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,