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 10 Recap

The Power BI Community Show

Watch the playback when Amit Chandak, a Power BI Super User, demos how to use Field Parameters to make reports more dynamic.

Power BI Dev Camp Session 26

New Date - Check it Out!

Mark your calendars and join us on Thursday, October 6 at 11a PDT for a great session with Ted Pattison!

Health and Life Sciences Power BI User Group

Health and Life Sciences Power BI User Group

Power BI specialists at Microsoft have created a community user group where customers in the provider, payor, pharma, health solutions, and life science industries can collaborate.

Top Solution Authors