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.
My data has years 2018 to 2021. I am comparing sales with the previous years and have created different DAX for that but for dynamic header based on selection of year, I am using below mentioned DAX but not getting the required result;
Selected value = Calendar Year (filter)
Solved! Go to Solution.
Hi @Saadahmedqu
Thanks for reaching out to us.
please use the sample file attached below
Best Regards,
Community Support Team _Tang
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.
Hi @Saadahmedqu
Thanks for reaching out to us.
please use the sample file attached below
Best Regards,
Community Support Team _Tang
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.
Hi,
Based on my test your measure seems to be working. Here is an improved dax using variables:
If this still doesn't work I recommend cheking what filters affect your visuals. The issue might be there.
Proud to be a Super User!
Thank you so much for your reply. I have used your solution also but even then it is not displaying result in card
The card displayed above based on selection is DAX used by me and the second card displaying cross sign is the query you provided. I think the problem is with multiple conditions based on the selection with hasvalue. There are no filters applied on visuals or page.
Below is the solution provided by you;
Can this issue be solved by fixing it to min year criteria?
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
23 | |
7 | |
7 | |
6 | |
6 |
User | Count |
---|---|
27 | |
12 | |
10 | |
9 | |
6 |