Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
10 years ago
Solved

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...
Need Help
  • ankitpatira's avatar
    ankitpatira
    10 years ago

    Anonymous you can create a measure and use HASONEVALUE and FIRSTNONBLANK in conjunction to achieve this. Check out this example I've provided.

ankitpatira's avatar
ankitpatira
Community Champion
10 years ago

Anonymous you can create a measure and use HASONEVALUE and FIRSTNONBLANK in conjunction to achieve this. Check out this example I've provided.

  • Anonymous's avatar
    Anonymous
    Not applicable
    10 years ago

    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