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.
Go to Solution.
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
@tamerj1 Great! Thank you for your solution. This is working fine.
Take a look at the September 2023 Power BI update to learn more.
Join Microsoft Reactor and learn from developers.