Creating a Slicer

[Lorraine]

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 to create a slicer that will allow me to select a line measure value and have only the selected line display with the column values?

Thanks in advance!

[dani0010 · Accepted solution]

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.

[Lorraine]

@dani0010 Thank you so much, that worked perfectly! You're a genius

[Lorraine]

@dani0010 Thanks! This makes sense, but how do I create a table in Power BI? I've only been importing them.

[dani0010]

@Lorraine You're in for a whole new world!