Line and Clustered column chart goes weird after publishing for slicer with no line data

[AnshulGupta]

Dears

I am using Line and Clustered Column chart with a slicer where for one selection, there is no value available for the line data. The chart behaves all good on desktop but behaves weirdly when published. Either the plot does not change or nothing shows up in the chart while there are values in the column.

Much to annoyance, I found the issue happens when markers are turned on. So, when I turn them off, everything is ok.

Here is sample data. Plot Product on X axis, year as legend, Values as column value and Budget as Line. Make sure markers are turned on for Line

Then have slicer of Location. As you can see there is no Budget value for Y location.  Select Y, you can notice no issues on desktop. But then publish this to web and you would notice on web, selecting Y either doesn't change anything in plot or makes it totally blank.

Year	Product	Location	Value	Budget
FY20	A	X	10	11
FY20	A	Y	15
FY20	B	X	18	19
FY20	B	Y	20
FY20	C	X	30	29
FY20	C	Y	28
FY21	A	X	12	13
FY21	A	Y	18
FY21	B	X	22	25
FY21	B	Y	25
FY21	C	X	32	35
FY21	C	Y	35

[nickyvv · Accepted solution]

Hi @AnshulGupta,

I can confirm this bug is happening in the service. Other people also already reported this to Microsoft and they are working on a fix at the moment.

[AnshulGupta]

Thank you. At least I found the workaround (i.e. to turn Off markers), and hopefully it will help the community to have something working in between.