Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
manojk_pbi
Helper IV
Helper IV

Create table based on year filter

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

 

YearMonthYearDim1Dim2KPIPlannedDate
2024Jan-24AA180%Aug-24
2024Feb-24BB190%Dec-24
2025Jan-25AA275%Jan-25
2025Feb-25BB280%Feb-25
2025Jan-25CC275%Jan-26
2025Jan-25DD280%Jan-27

 

Expected Output when Year 2025 selected

Data is for year - 2025

Dim1KPIPlanned 
A75%Jan-25
B80%Feb-25
1 ACCEPTED SOLUTION
mdaatifraza5556
Super User
Super User

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])


Screenshot 2025-04-07 154504.png

 


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

 

Screenshot 2025-04-07 163212.png

 

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

View solution in original post

4 REPLIES 4
v-vpabbu
Community Support
Community Support

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

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

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
Super User
Super User

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])


Screenshot 2025-04-07 154504.png

 


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

 

Screenshot 2025-04-07 163212.png

 

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

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.