cancel
Showing results for
Did you mean:
Highlighted
Frequent Visitor

## Change horizontal/constant line based on slicer selection

Hi,

Is there a way to change the constant line based off the slicer selection? I have a slicer with four different options and each of them have different capacities. Is there a way for a constant horizontal line to change based off the slicer selection wihtout having to manually insert the capacities in the table.

Thanks!

1 ACCEPTED SOLUTION

Accepted Solutions
Super User

## Re: Change horizontal/constant line based on slicer selection

Hi @NoaB ,

You need to add a measure that makes the calculation for each of your option on the slicer, something like this:

```Flat Line =
SWITCH (
SELECTEDVALUE ( Table2[Capacity] );
"A"; 20;
"B"; 25;
"C"; 5;
"D"; 40;
80
)```

This needs to be adjusted to your needs but as you can see below the numbers change accordingly

Regards,

MFelix

Proud to be a Datanaut!

6 REPLIES 6
Super User

## Re: Change horizontal/constant line based on slicer selection

Hi @NoaB ,

You need to add a measure that makes the calculation for each of your option on the slicer, something like this:

```Flat Line =
SWITCH (
SELECTEDVALUE ( Table2[Capacity] );
"A"; 20;
"B"; 25;
"C"; 5;
"D"; 40;
80
)```

This needs to be adjusted to your needs but as you can see below the numbers change accordingly

Regards,

MFelix

Proud to be a Datanaut!

Frequent Visitor

## Re: Change horizontal/constant line based on slicer selection

Hi @MFelix ! Thanks for your response!

I tried your approach and I'm still having some issues. Is Table2[Capacity] the table that has a column "Capacity" which results in the options for the slicer?

I attempted thios measure below and was receiving an error "Unexpected expression" for everything starting after the semicolon after "SELECTEDVALUE( HourlyCapacityWithETA[PoolName] );"

Flat Line =
SWITCH(
SELECTEDVALUE( HourlyCapacityWithETA[PoolName] );
"Var1"; 220;
"Var2"; 220;
"Var3"; 70;
"Var4"; 364;
)

Super User

## Re: Change horizontal/constant line based on slicer selection

Hi @NoaB ,

This as to do with regional settings, on some systems it uses the dot comma on other only comma.

```Flat Line =
SWITCH(
SELECTEDVALUE( HourlyCapacityWithETA[PoolName] ),
"Var1", 220,
"Var2", 220,
"Var3", 70,
"Var4", 364
)```

Regards,

MFelix

Proud to be a Datanaut!

Frequent Visitor

## Re: Change horizontal/constant line based on slicer selection

Amazing! Thank you @MFelix !

Do you know if there is a way to send an alert for static data when the data crossed the capacity line?

Super User

## Re: Change horizontal/constant line based on slicer selection

Hi @NoaB ,

Regards,

MFelix

Proud to be a Datanaut!

Frequent Visitor

## Re: Change horizontal/constant line based on slicer selection

Hi @MFelix ,

I've been looking into Power BI's functionality for sending out alerts. However it only works for livestream data for KPIs and gauges visuals. I was wondering if there functionality for a static data set that if the graph reaches a certain threshold a notification can appear.

Announcements

#### Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

#### Community News & Announcements

Get your latest community news and announcements.

#### Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

#### Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Top Kudoed Authors
Users Online
Currently online: 311 members 3,302 guests
Recent signins: