Forum Discussion
Slicer Visualization
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
Anonymous you can create a measure and use HASONEVALUE and FIRSTNONBLANK in conjunction to achieve this. Check out this example I've provided.
2 Replies
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