topic Create table based on year filter in Developer

Create table based on year filter

manojk_pbi — Mon, 07 Apr 2025 09:39:19 GMT

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

Re: Create table based on year filter

mdaatifraza5556 — Mon, 07 Apr 2025 11:03:11 GMT

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.

Re: Create table based on year filter

Anonymous — Fri, 11 Apr 2025 14:02:38 GMT

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

Re: Create table based on year filter

Anonymous — Mon, 14 Apr 2025 13:41:12 GMT

Hi @manojk_pbi,

Regards,
Vinay Pabbu

Re: Create table based on year filter

Anonymous — Thu, 17 Apr 2025 12:10:34 GMT

Hi @manojk_pbi,

Regards,
Vinay Pabbu