cancel
Showing results for 
Search instead for 
Did you mean: 

bug in line chart with small multiples

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.

taikvei_0-1658141930742.png
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):

taikvei_1-1658141991358.png
and if I have it as a 1 row 1 column, it shows as expected also:

taikvei_2-1658142030845.png

taikvei_3-1658142038257.png

 


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)

taikvei_4-1658142194062.png

 

Am I missing something or is this a bug?

Many thanks

 

 

 

Status: Needs Info

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

Comments
Ailsa-msft
Community Support
Status changed to: Needs Info

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
Frequent Visitor

Hello @Ailsa-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