Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi All,
Is there any work around to use the values passed by the slicer visualization as a parameter in the Measure calculation..?
Like Slicer Year has 2 values 2014 and 2015
When I select 2015 I want to pass the 2015 as a parameter to a function like
PreviousYear() to get its previous year value dynamically.
Thanks in advance
Solved! Go to Solution.
Hi @ankitpatira,
That works fine i tried following expression in a measure
Title = IF(HASONEVALUE(Table[Year]),FIRSTNONBLANK(Table[Year],TRUE),0)
I am getting 2015 or 2014 depending upon my selection
but i want to use it like this
1. CALCULATE(Fact[Revenue],FILTER(Table,Table[Year] = [Title])) as 'Current Year Revenue'
2. CALCULATE(Fact[Revenue],FILTER(Table,Table[Year] = [Title]-1)) as 'Previous Year Revenue'
when i select 2015 in the slicer
1 is coming but there is no data for 2.
did i miss anything?
the chart will display both the measures in value section
Categories: Months
Values: Current Year Revenue
Previous Year Revenue
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 |
---|---|
112 | |
97 | |
80 | |
69 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |