cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
dtartaglia
Resolver I
Resolver I

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

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).

 

chart01.PNG

 

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.

 

chart02.PNG

1 ACCEPTED SOLUTION
Habib
Responsive Resident
Responsive Resident

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 🙂

View solution in original post

2 REPLIES 2
Habib
Responsive Resident
Responsive Resident

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 🙂

Thanks!

 

The Measure I needed/worked for my situation is:

 

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

Helpful resources

Announcements
September Update

Check it Out!

Click here to learn more about the September 2022 updates!

Power BI Show episode 9

The Power BI Community Show

Watch the playback when Priya Sathy and Charles Webb discuss Datamarts! Kelly also shares Power BI Community updates.

Power BI Dev Camp Session 25

Ted's Dev Camp - August 25, 2022

Watch Session 25 of Ted's Dev Camp.

Top Solution Authors