Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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 |
Solved! Go to 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")
--> In the slicer use the extracted PlannedYear column
--> Output
If this answers your questions, kindly accept it as a solution and give kudos.
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
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")
--> In the slicer use the extracted PlannedYear column
--> Output
If this answers your questions, kindly accept it as a solution and give kudos.
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
6 | |
6 | |
3 | |
2 | |
2 |