Relationship - show lines with no values

[ArielK]

HI All

I am trying to achieve something that in my head seems easy, but I can't find solution.

I have 2 tables:

- Stock - with sales indexes like this:

index	parameter
a	x
b	y
c	x
d	z

- second with sales, like this:

index	date	sales
a	1.2024	100
a	2.2024	50
a	3.2024	40
c	1.2024	10
c	2.2024	15
c	3.2024	13

There is one way relationship between those tables (stock filters sales). 

I made matrix visual where I want to show all indexes from first table and sales if there was any.

I don’t want sales table to filter index table. I expect to achieve, something like this:

		1.2024	2.2024	3.2024
a	x	100	50	40
b	y
c	x	10	15	13
d	z

It works ok for the indexes that have sales but indexes that have no sales are filtered, so i end up with such visual:

		1.2024	2.2024	3.2024
a	x	100	50	40
c	x	10	15	13

Is there any way to avoid this filtering? is there somewhere option "show lines with no values" etc.?

I tried to change relationship type, run through settings but still no success.

I would really appreciate your support.

Thank you!

[ArielK]

Thanks a lot! I was pretty sure that I saw option like this somewhere, but I spent 2 hours digging through settings and finally lost hope. 😉

[DataInsights · Accepted solution]

@ArielK,

Click the down arrow for the field in the field well, and select "Show items with no data".