Get details when click on the line chart

[Puja_Kumari25]

Hi All, 

I need your help on, how to get details in a table when we click on Line chart.

I am generating a line chart graph for the resource count monthly using the start date and End date, and when we click on the data marker it needs to show their details in the table

resource table
id, start date, end date, resouce_name
1,1/1/2022,1/1/2023, Ram
2,1/1/2022,1/8/2023, Riya

Number of Resources Present =
VAR EndDatePerVisual = MAX('Calendar'[Date])
VAR StartDatePerVisual = Min('Calendar'[Date])
VAR RESULT =
CALCULATE(
[Number of Resource],--(count dax to count no of resources)
REMOVEFILTERS('Calendar'),
resourcetable[Start_Date] <= EndDatePerVisual,
resourcetable[Ending_Date] >= StartDatePerVisual
||
ISBLANK( resourcetable[Ending_Date])
)
RETURN
RESULT

line chart is working fine but not able to fetch resource details.

Thanks in advance.

[v-jianboli-msft · Accepted solution]

Hi @Puja_Kumari25 ,

Tooltips are an elegant way of providing more contextual information and detail to data points on a visual. 

You can add the cost to Tooltips:

Output:

For more details, please refer to:

Customizing tooltips in Power BI Desktop - Power BI | Microsoft Learn

Best Regards,

Jianbo Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Puja_Kumari25]

Thank you for the help

[Puja_Kumari25]

https://drive.google.com/drive/folders/1qc2XVJjqfiyh7L_HFytYlFVTBsQEkkJX?usp=sharing

please find the link for the sample pbix file

[daXtreme]

@Puja_Kumari25 

The model in the file is not the same as the code depicts. Your code above refers to some Calendar table which is not present in the file. Why have you removed it from the sample file? This does not make things easier because now I don't know what the relationships are between tables...

[daXtreme]

Please supply sample data to play with. You can paste a link to a file on a shared drive (OneDrive, Google...). Don't forget to grant public access rights to the file.