bug in line chart with small multiples

[taikvei]

Hello,

I have a line chart a categorical X axis and numerical Y axis.

I have inserted a simple IF(client IN {1,2,3}, "EU","Non-EU") statement to categorise my data for small multiples.

When I add the small multiple to the chart, and have the small multiple grid layout with >1 row, it shows a client in both small multiples. This client is different based on which metric I am using, but always 1 is shown in both small multiples. Screenshot 1: you can see with series label enabled, the "Dkpifc"  is shown in both categories, although it only has a value in the EU one.

if I then change the layout to be 1 row and 2 columns, the Dkpifc value is only shown in one of them (disappears from Non-EU as expected):

and if I have it as a 1 row 1 column, it shows as expected also:

This is only an issue when using a line chart, as if I use a bar chart, and filter toi only DKpifc, it does not show up (although since it's not got a value it might be there, just not showing up as the series label is not there)

Am I missing something or is this a bug?

Many thanks

[v-yetao1-msft]

Hi @taikvei 

I tried to restore the scenario you mentioned, but it failed, can you provide your pbix file(remove sensitive info) ?

Best Regards,
Community Support Team _ Ailsa Tao

[taikvei]

Hello @v-yetao1-msft ,

It wouldn't let me upload it directly to the message, saying

The file type (.pbix) is not supported.

I have uploaded it here, let me know if that works or if I can provide the file in a different way?

https://easyupload.io/kq2l72

Many thanks