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
Community SupportHi LuckyLuke ,
Sorry for that, We cannot understand your requirement clearly, Do you mean the see record feature in the Scatter Visual? Could you please provide a mockup sample based on fake data or describle the fields of each tables and the relations between tables simply? It will be helpful if you can show us the exact expected result based on the tables. Please upload your files to One Drive and share the link here.
Please don't contain any Confidential Information or Real data in your reply.
Best regards,
Hi v-lid-msft ,
The visuals I'm using is a column chart but yes it is the same as the see record feature in PBI Desktop. In the last few months this has been renamed on the web app to "show data points as a table".
I will try to create a mock-up with sample data but this will take some time so I will describe the tables here.
Table : Calendar
Fields: Date, Weeks Since, (various other typical calculations for a date table)
Table: Case
Fields: Case Key, Date Received, Date Closed, Date Transferred to Dept, Date of Last Action, (various other dimension keys)
There are various other dimension tables but they aren't relevant to this issue.
I have inactive relationships from all 4 date fields in the Case table to the Calendar table.
I have 4 measures on the Calendar table that use USERELATIONSHIP. E.g.
Sample Measure:
Complaints Closed = CALCULATE(COUNT(Case[Case Key]),USERELATIONSHIP('Calendar'[Date],Case[Date Closed]))
In the Column chart visual I have the Week Since as the Axis, and the measure as the Value. This works fine for the visual itself and the chart looks as expected however the users need to be able to right click on a bar in the chart and get a list of the Case Keys for that cohort of cases (e.g. cases where there the last action was 10 weeks ago). See records in PBI Desktop (or show data points as a table in the web app) would normally do this, but because I am using the measures I don't get that option.
Due to the 4 inactive relationships I don’t know how to filter the data without using the measures and USERELATIONSHIP. Is there another way to do it so that “view records” is available?
I hope this is clearer?