Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi All,
Please help me to get the details when we click on the start and end date line chart.
We have created a line chart with three lines generated from the resource count based on the current month's recourse count, start-month resource count, and end-month resource count.
We are able to get detail when we click on the current month line chart data point. but not able to get details when we click on the start and end month line chart data points.
Attaching the sample file link for the reference. Thanks in advacne.
https://drive.google.com/file/d/1Ycxa6OfTnF2vsSjnDE_OyhQdycd-dvQ4/view?usp=share_link
With Regards
PK
Solved! Go to Solution.
Hi All,
Please help me to get the details when we click on the start and end date line chart.
We have created a line chart with three lines generated from the resource count based on the current month's recourse count, start-month resource count, and end-month resource count.
We are able to get detail when we click on the current month line chart data point. but not able to get details when we click on the start and end month line chart data points.
Attaching the sample file link for the reference. Thanks in advacne.
https://drive.google.com/file/d/1PTEeY9C4BIx5QWQqDon6LQtfcaFoWVVZ/view?usp=share_link
Hi @Puja_Kumari25 ,
Please try:
First Duplicate table 1
Then apply the measure:
Measure =
var _a = SELECTEDVALUE(DateTable[YearMonthnumber])
var _b = IF(FORMAT(MAX('Table 2'[StartDate]),"YYYYMM")=_a,"Start")
var _c = IF(FORMAT(MAX('Table 2'[EndDate]),"YYYYMM")=_a,"End")
var _d = IF(MIN(DateTable[DateAsInteger])in SELECTCOLUMNS('Table 2',"YYYYMMDD",[YYYYMMDD]),"Current")
return _b&" "&_c&" "&_d
Final output:
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.
Thanks for your support, the shared solution was really helpful. I have accepted this as a solution.
Hi All,
Please help me to get the details when we click on the start and end date line chart.
We have created a line chart with three lines generated from the resource count based on the current month's recourse count, start-month resource count, and end-month resource count.
We are able to get detail when we click on the current month line chart data point. but not able to get details when we click on the start and end month line chart data points.
Attaching the sample file link for the reference. Thanks in advacne.
https://drive.google.com/file/d/1PTEeY9C4BIx5QWQqDon6LQtfcaFoWVVZ/view?usp=share_link
Hi @Puja_Kumari25 ,
Sorry, I can't view anything and download it.
Please provide me with more details about your table and your problem or share me with your pbix file after removing sensitive data.
Refer to:
How to provide sample data in the Power BI Forum
How to Get Your Question Answered Quickly
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.
Hi @Puja_Kumari25 ,
Based on your description, it seems like there should be three lines in your line graph, but there seems to be only one line in the sample you provided? How should these three lines look like and how exactly are they calculated?
Please provide me with more details about your table and your problem or share me with your pbix file after removing sensitive data.
Refer to:
How to provide sample data in the Power BI Forum
How to Get Your Question Answered Quickly
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.
Hi Jianboli,
I have updated the new pbix file on the same location. It has three lines on the Line chart.
With regards
pk
User | Count |
---|---|
41 | |
27 | |
23 | |
18 | |
15 |
User | Count |
---|---|
54 | |
35 | |
19 | |
18 | |
15 |