cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper I
Helper I

Creating a Slicer

Hi all,

 

This is a line and stacked column visual I'm working on right now:

Screenshot (5).png

 

 

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!

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Frequent Visitor

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.

View solution in original post

4 REPLIES 4
Highlighted
Frequent Visitor

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.

View solution in original post

Highlighted

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

Highlighted

datatable.png

 

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

Highlighted

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

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors
Top Kudoed Authors