Display line in line chart instead of zero

[Anonymous]

Hi - I have a Sprint name slicer and a line graph. When I select a Particular sprint name in the slicer,  the line graph changes from a line to a dot and displays particular sprint data.

The line graph consists of axis-=sprint name, values=planed pbis, completed issues,  secondary values= done to plan %.
I want the line to display the particular sprint name I select in the slicer. so here it is displaying a dot instead of line
If no sprint name is selected in the slicer, it is showing for all sprint names in a line chart. I want to display a line for the particular sprint name I select in slicer.  

So here I am attaching the pics when I am not selecting any sprint name in the slicer it is showing a line for all sprint names when I am selecting a name it is showing a dot. so I need to display a line for the name I select in the slicer.

[v-easonf-msft · Accepted solution]

Hi,  @Anonymous 

As a workaround, you may consider adding three auxiliary lines to the Analytics pane of  line chart .

something like:

M_Completed = IF(HASONEVALUE('Table'[SPRINT_NAME]),AVERAGE('Table'[Completed]),BLANK()) 
// AVERAGE('Table'[Doen to Plan])can be replaced by any measure your need

M_Donetoplan = IF(HASONEVALUE('Table'[SPRINT_NAME]), AVERAGE('Table'[Doen to Plan]) ,BLANK())

M_Planned PBIS = IF(HASONEVALUE('Table'[SPRINT_NAME]),AVERAGE('Table'[PLANNED PBIS]),BLANK())

The result will show as below:

Please check my sample file for more details.

Best Regards,
Community Support Team _ Eason

[v-easonf-msft · Accepted solution]

Hi,  @Anonymous 

As a workaround, you may consider adding three auxiliary lines to the Analytics pane of  line chart .

something like:

M_Completed = IF(HASONEVALUE('Table'[SPRINT_NAME]),AVERAGE('Table'[Completed]),BLANK()) 
// AVERAGE('Table'[Doen to Plan])can be replaced by any measure your need

M_Donetoplan = IF(HASONEVALUE('Table'[SPRINT_NAME]), AVERAGE('Table'[Doen to Plan]) ,BLANK())

M_Planned PBIS = IF(HASONEVALUE('Table'[SPRINT_NAME]),AVERAGE('Table'[PLANNED PBIS]),BLANK())

The result will show as below:

Please check my sample file for more details.

Best Regards,
Community Support Team _ Eason

[Anonymous · Accepted solution]

Hi, @v-easonf-msft 

This issue has been resolved by your solution. Thank you for your valuable time and support.  It means a lot having such great support! Hoping for this support when again needed.

[lbendlin]

Please consider using a different visual type for this data.  A line chart should only be used for temporal continuity data.