Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Dear Power BI community,
I would like to ask for your help as I am trying to use DAX formula SELECTEDVALUE based on field parameters, however it is not doable based on the following error message:
IF user selects between two value the (Amount USD & Amount LCL) the calculation should be changing based on that:
DAX formula :
Field Parameter:
Visualization selection for Amount USD & Amount LCL:
Would it be possible for someone to help how to change the DAX formula SELECTEDVALUE part to make it work?
Thank you for your advice in advance.
Wishing you a wonderful date.
Adam
Solved! Go to Solution.
Can you perhaps upload a example file without sensitve datas?
Other post to field parameters
It seems to be possible. Perhaps try first to access only to the field parameter value?
Proud to be a Super User!
Did you try to add a "calculate" in the var Lastyeardynamic:
Lastyeardynamic = calculate(max(DWH[year])) ?
Proud to be a Super User!
What was the solution now in your case ? 🙂
Proud to be a Super User!
I have added the year column values explicitly instead of using a MIN & MAX measure to find the first and last year in the year column.
I am not 100% clear how it connects to the original issue to be honest but solved the problem.
Did you try to add a "calculate" in the var Lastyeardynamic:
Lastyeardynamic = calculate(max(DWH[year])) ?
Proud to be a Super User!
Oh thank you I have added calculate and it made the formula more dynamic. Thank you.
Can you perhaps upload a example file without sensitve datas?
Other post to field parameters
It seems to be possible. Perhaps try first to access only to the field parameter value?
Proud to be a Super User!
One question: Why it is important to use field parameters instead of a regular table / calculated table?
Proud to be a Super User!
Thank you Andhi for your quick reply.
Actually the main reason for that is that this was the only way (based on my knowledge) how I could dynamically change the column chart visualization Y axis between amount usd and amount lcl based on the field parameter selection:
Is it inefficient to do so?
Thank you,
Adam
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
54 | |
27 | |
23 | |
14 | |
11 |
User | Count |
---|---|
77 | |
62 | |
44 | |
17 | |
12 |