Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
Hi All,
I am stuck on a verge of closure, please help.
I have a table where i have create 2 column one financials in Euros and another one Financials in Dollar.
I need to display the values as per filter Selection of currency - Euro/USD
I tried switch function, it did not work for multiple values hence i thought of creating another another column with IF Statement and take the output for my work but i am getting the above error, Please guide it is urgent. I need the output in column to create waterfall chart of financials
Solved! Go to Solution.
@Anonymous
You are trying to create a column with a slicer value. Only a measure can use Slicer Value.
new mesure =
if([selected Value] ="EUR",max(Waterfall[Result]),max(Waterfall[Result2]))
@Anonymous
You are trying to create a column with a slicer value. Only a measure can use Slicer Value.
new mesure =
if([selected Value] ="EUR",max(Waterfall[Result]),max(Waterfall[Result2]))
hi @Anonymous
try SELECTEDVALUE():
= if(selectedvalue([selected currency]) = "eur", [Result], [Result2])
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
77 | |
76 | |
57 | |
36 | |
34 |
User | Count |
---|---|
99 | |
56 | |
56 | |
46 | |
40 |