topic Re: Display stacked bar chart only if one of the filter metrics has a greater than zero value in DAX Commands and Tips

Display stacked bar chart only if one of the filter metrics has a greater than zero value

JBussone — Wed, 30 Jul 2025 20:41:09 GMT

I am working building out a report with a stack bar chart and I am attempting to write a dax query to display the data as intended. The Data is from the NHL. I have pulled three columns as metrics into my report(they have whole number values):

1. I_F_highDangerGoals

2. I_F_mediumDangerGoals

3. I_F_lowDangerGoals

Now I am pulling those metrics into a stacked bar chart, but I do not want to show any players who have zero goals for ALL three metrics. If they have a greater than zero value for one of those three metrics, I want to display that player. I have tried multiple different queries and cannot seem to get it right. Thank you for any help you can provide!

Re: Display stacked bar chart only if one of the filter metrics has a greater than zero value

MasonMA — Wed, 30 Jul 2025 21:29:41 GMT

Hello JBussone

You may try applying below measure to the visual-level filter on your stacked bar chart and Set ' is =1'.

IF (
SUM('table'[I_F_highDangerGoals]) +
SUM('table'[I_F_mediumDangerGoals]) +
SUM('table'[I_F_lowDangerGoals]) > 0,
1,
0
)

Hope this works:)

Re: Display stacked bar chart only if one of the filter metrics has a greater than zero value

JBussone — Wed, 30 Jul 2025 22:04:31 GMT

I am so sorry Mason ! I am very new to Power BI and it has changed a lot since last time I used it(10 yrs ago). I believe I have the correct format but in dax it is showing that my IF statement syntax is incorrect. I assume I would create this this visual filter and it will be selectable in the Data pane once created; After that I can use it under ""Filters on this visual"?

PlayerGoalsFiltered =

IF (

SUM('skaters'[I_F_highDangerGoals]) +

SUM('skaters'[I_F_mediumDangerGoals]) +

SUM('skaters'[I_F_lowDangerGoals]) > 0,

)

Re: Display stacked bar chart only if one of the filter metrics has a greater than zero value

JBussone — Wed, 30 Jul 2025 22:08:34 GMT

MasonMA I just figured it out! Thank you so much for your help! I hope you have a great rest of your day! 🙂

Re: Display stacked bar chart only if one of the filter metrics has a greater than zero value

MasonMA — Wed, 30 Jul 2025 22:12:29 GMT

Happy to see it works! You can also mark this as solution so other people can find it:)