Create table based on year filter

[manojk_pbi]

Hello Friends,

I have data like below in my report, i need to create a KPI table based on the selection. When selection is made on year, need to fileter the data planned in 2024 using PlannedDate column. How can we acheive this ?

Another this is how can we add lable based on the selection stating "Data is for year - <Dynamic Year>"

Year	MonthYear	Dim1	Dim2	KPI	PlannedDate
2024	Jan-24	A	A1	80%	Aug-24
2024	Feb-24	B	B1	90%	Dec-24
2025	Jan-25	A	A2	75%	Jan-25
2025	Feb-25	B	B2	80%	Feb-25
2025	Jan-25	C	C2	75%	Jan-26
2025	Jan-25	D	D2	80%	Jan-27

Expected Output when Year 2025 selected

Data is for year - 2025

Dim1	KPI	Planned
A	75%	Jan-25
B	80%	Feb-25

[v-vpabbu]

Hi @manojk_pbi,

Thanks @mdaatifraza5556 for Addressing the issue.

we would like to follow up to see if the solution provided by the super user resolved your issue. Please let us know if you need any further assistance.
If our super user response resolved your issue, please mark it as "Accept as solution" and click "Yes" if you found it helpful.

Regards,
Vinay Pabbu

[v-vpabbu]

Hi @manojk_pbi,

we would like to follow up to see if the solution provided by the super user resolved your issue. Please let us know if you need any further assistance.
If our super user response resolved your issue, please mark it as "Accept as solution" and click "Yes" if you found it helpful.

Regards,
Vinay Pabbu

[v-vpabbu]

Hi @manojk_pbi,

we would like to follow up to see if the solution provided by the super user resolved your issue. Please let us know if you need any further assistance.
If our super user response resolved your issue, please mark it as "Accept as solution" and click "Yes" if you found it helpful.

Regards,
Vinay Pabbu

[mdaatifraza5556 · Accepted solution]

Hi @manojk_pbi 

Please follow the below steps to acheive you result.

--> Created calculated columns 

   1. formated PlannedDate using below DAX.
             Planned_Date = FORMAT('Table'[PlannedDate], "mmm-yyyy")

   2. Extracted year from PlannedDate using below DAX.
             PlannedYear = YEAR('Table'[PlannedDate])



--> For a dynamic title, create a measure using the below DAX.
               Selected Year DY_Label =

                                      "Data is for year - " & SELECTEDVALUE('Table'[PlannedYear], "No year selected")

 
--> In the slicer use the extracted PlannedYear column


--> Output
         

 If this answers your questions, kindly accept it as a solution and give kudos.