Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
@Anonymous you can create a measure and use HASONEVALUE and FIRSTNONBLANK in conjunction to achieve this. Check out this example I've provided.
@Anonymous you can create a measure and use HASONEVALUE and FIRSTNONBLANK in conjunction to achieve this. Check out this example I've provided.
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
User | Count |
---|---|
94 | |
79 | |
73 | |
63 | |
60 |
User | Count |
---|---|
108 | |
100 | |
77 | |
63 | |
61 |