topic Re: Get details when click on the line chart in DAX Commands and Tips

Get details when click on the line chart

Puja_Kumari25 — Tue, 15 Nov 2022 08:10:24 GMT

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.

Re: Get details when click on the line chart

daXtreme — Tue, 15 Nov 2022 14:47:25 GMT

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.

Re: Get details when click on the line chart

Puja_Kumari25 — Tue, 15 Nov 2022 15:38:16 GMT

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

please find the link for the sample pbix file

Re: Get details when click on the line chart

daXtreme — Tue, 15 Nov 2022 17:24:08 GMT

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...

Re: Get details when click on the line chart

v-jianboli-msft — Mon, 21 Nov 2022 07:39:07 GMT

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.

Re: Get details when click on the line chart

Puja_Kumari25 — Mon, 21 Nov 2022 08:56:43 GMT

Thank you for the help