Forum Discussion
Determine Axis Values based on Cursor Position
...image re-uploaded as requested...
Cheers.
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,
Hi Simon,
What I'm hoping to be able to do is:
- click on chart
- click on relevant month within chart
- 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.
Sorry dude,
Currently this option not available in Power BI. But interaction will work.
like if u click on the Month in Line chart it will sort the rest of the chart with relavant month u clicked in line chart.
let me if any help
When you click on relevant month within your chart, your DAX formula supposes to be sliced by month level (if you don't ignore filters in your formula). Howerver, it can't get a specific date value based on the selection position within the Month bar/column in your chart.
Regards,
