Forum Discussion
How can I control what is in the Data Point Table?
If I'm understanding correctly you have 3 options
1) add a table on the same page as the chart. You can then filter the table by clicking the column/scatter data point
2) Add a custom tooltip.
Create a new tooltip page and use the date as a tooltip filter.
https://docs.microsoft.com/en-us/power-bi/desktop-tooltips
When you hover over the column the tooltip will show and filter by the matching date
3) Drillthrough.
Similar to the tooltip you can add a new page and set the drillthrough filter to the date. You then get a right mouse option to drill through from your column chart.
https://docs.microsoft.com/en-us/power-bi/desktop-drillthrough
Memorable MemberIf I'm understanding correctly you have 3 options
1) add a table on the same page as the chart. You can then filter the table by clicking the column/scatter data point
2) Add a custom tooltip.
Create a new tooltip page and use the date as a tooltip filter.
https://docs.microsoft.com/en-us/power-bi/desktop-tooltips
When you hover over the column the tooltip will show and filter by the matching date
3) Drillthrough.
Similar to the tooltip you can add a new page and set the drillthrough filter to the date. You then get a right mouse option to drill through from your column chart.
https://docs.microsoft.com/en-us/power-bi/desktop-drillthrough
Hi stretcharm ,
Thank you for your reply and great suggestions!
It took me a little while to figure out that to do it this way I need to include the measure in the table to get the inactive relationship to be used, but once I figured that out it works great.
I need to have multiple drillthrough forms with the measure I want included on each but as the forms can all me named the same this is invisible to the user.
Now I just need to figure out how I can hide the measure as it's just showing 1 for each row.
Many thanks for you help. 😀