topic Re: constant line based on filter in DAX Commands and Tips

constant line based on filter

Jeffrey_VC — Wed, 07 Jun 2023 12:17:21 GMT

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

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

tamerj1 — Wed, 07 Jun 2023 13:22:53 GMT

you may try something like

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

Jeffrey_VC — Wed, 07 Jun 2023 13:43:29 GMT

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