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.
Hi guys,
I just started with power bi and I need a help.
I have this data:
Name Year Actual year Status
A 2023 2024 Down
B 2024 2024 Attention
C 2025 2024 Up
D 2026 2024 Up
I need to have a data parameter.
Scenario 1 - The current year should always bring the attention status. However, if I select the current year for 2026, names A,B,C should be down and name D should be attention.
Scenario 2 - If I select the current year to be 2025, names A,B should be down, name C should be attention and name D, up.
I don't have a dashboard yet.
Anyone can help me?
Thanks a lot.
Solved! Go to Solution.
Hi @msam86 - I have checked as per sample data shared, can you please use the below dax logic
create a parameter with numeric range, and specify the year values from 2023 to 2026 with increment 1
Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!
Proud to be a Super User! | |
Hi @rajendraongole1 ,thanks for the quick reply, I'll add further.
Hi @msam86 ,
The Table data is shown below:
Please follow these steps:
1. Create a parameter with numeric range
2.Use the following DAX expression to create a measure(Be careful not to create calculated columns)
Measure =
VAR SelectedYear = SELECTEDVALUE('Current Year'[Current Year])
RETURN
SWITCH(
TRUE(),
YEAR(MAX('Table'[YEAR])) < SelectedYear, "Down",
YEAR(MAX('Table'[YEAR])) = SelectedYear, "Attention",
YEAR(MAX('Table'[YEAR])) > SelectedYear, "Up",
MAX('Table'[Status]) -- Default to the original status if no condition matches
)
3.Final output
Details can be found in the .pbix file. If the problem is solved, please mark @rajendraongole1 and I as the solution.
Hi @rajendraongole1 ,thanks for the quick reply, I'll add further.
Hi @msam86 ,
The Table data is shown below:
Please follow these steps:
1. Create a parameter with numeric range
2.Use the following DAX expression to create a measure(Be careful not to create calculated columns)
Measure =
VAR SelectedYear = SELECTEDVALUE('Current Year'[Current Year])
RETURN
SWITCH(
TRUE(),
YEAR(MAX('Table'[YEAR])) < SelectedYear, "Down",
YEAR(MAX('Table'[YEAR])) = SelectedYear, "Attention",
YEAR(MAX('Table'[YEAR])) > SelectedYear, "Up",
MAX('Table'[Status]) -- Default to the original status if no condition matches
)
3.Final output
Details can be found in the .pbix file. If the problem is solved, please mark @rajendraongole1 and I as the solution.
Thanks a lot for the help!!! Amazing how power bi works!
@Anonymous Did you have the xls file?
Regards
Hi @rajendraongole1 thanks a lot for your help.
I think a made a mistake. I received an error:
Expressions that generate variable data types cannot be used to define calculated columns.
If you help me one more time, I'll appreciate.
Regards
Hi @msam86 - I have checked as per sample data shared, can you please use the below dax logic
create a parameter with numeric range, and specify the year values from 2023 to 2026 with increment 1
Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!
Proud to be a Super User! | |
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
72 | |
72 | |
38 | |
31 | |
26 |
User | Count |
---|---|
97 | |
86 | |
43 | |
40 | |
35 |