Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Creating a Slicer

Hi all,   This is a line and stacked column visual I'm working on right now:     For the line values I've created three measures and given them the values 58, 61, and 67. Is there a way ...
  • dani0010's avatar
    8 years ago

    You could create a table like this:

     

    UI Compare Line = DataTable(
    "Label", STRING, 
    "Value", INTEGER 
    ,{ 
    {"Keyword 1","61"}, 
    {"Keyword 2","58"}, 
    {"Keyword 3","67"} 
    } 
    )

     

    Bind that Label field to your slicer.

     

    Create a measure like this:

    UI Compare Line Selected = max('UI Compare Line'[Value])

    Use the measure as the line value in your chart.