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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Jeffrey_VC
Helper II
Helper II

constant line based on filter

Hello,

 

I'm trying to use a constant line into a stacked bar chart.

I want that the constant line is dynamic based on an filter.

 

This filter had three different values

  1. Normal
  2. Calamity
  3. Urgent

If I select for example "Urgent" the constant line must be 98% and when selected "Normal" the constant line must be 93%.

Hopefully someone can help me.

 

Jeffrey

1 ACCEPTED SOLUTION
tamerj1
Super User
Super User

Hi @Jeffrey_VC 

you may try something like 

Line =
IF (
NOT ISEMPTY ( 'Table' ),
SWITCH (
SELECTEDVALUE ( SlicerTable[Value] ),
"Calamity", 0.90,
"Normal", 0.93,
"Urgent", 0.98
)
)

View solution in original post

2 REPLIES 2
tamerj1
Super User
Super User

Hi @Jeffrey_VC 

you may try something like 

Line =
IF (
NOT ISEMPTY ( 'Table' ),
SWITCH (
SELECTEDVALUE ( SlicerTable[Value] ),
"Calamity", 0.90,
"Normal", 0.93,
"Urgent", 0.98
)
)

@tamerj1 
Great! Thank you for your solution. This is working fine.

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

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

Top Solution Authors