Can the line be removed from "Line and stacked column chart" if multiple values are found?

[dtartaglia]

Hi,

The line in the below chart is the Studio Skill Goal for a specific user Role per Studio per Tool in our firm (the line location matches the below/right Studio Skill Goal).

If all the Roles are selected (I unselect Designer), the line changes as you may expect (see below). Question: Is there a way to remove the line if this situation happens? If all Roles are selected, I do not want to show a line at all. For this particular chart it is ok but I want to add a new chart which will be similar except allow multiple tools to be selected.

[Habib · Accepted solution]

Add a column which counts the selection for selected Tools. Based on this column value you need to change your goal formula. Use SWITCH function and in case count is 1, calculate value as per your need and in case count is more than 1, retun 0. This way your line will be created on 0 line.

This is a workarround only 🙂

[dtartaglia]

Thanks!

The Measure I needed/worked for my situation is:

LineValueSet = if (DISTINCTCOUNT(SurveyDataTransposed[Tool])>1, 0, VALUES(CombinedStudioSkillTables[Studio Skill Goal Index]))