Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Lorraine
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
dani0010
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
dani0010
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.

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

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

datatable.png

 

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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.