Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
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])
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!