"Show items with no data"

[scolvin]

Hello,

I work on a PBI report on PBI Desktop with 2 Datasets on the PBI Service.
I start to work with dataset sources
Dataset "Sales" and Dataset "Discount".

I want to show the Sales Amount by Discount Type (if Discount then Discount Type else "Not discount")

The "Show items with no data" function doesn't work in my case.

It shows only the sales amount when there are discounts.

The RELATED function doesn't work to.

Do you think it's because my datasources are Dataset type ?

Thank you in advance for your support,

Regards

[olgad]

What if you set the filter direction both?

[scolvin]

If you're talking about the join, it doesn't change anything...

There is not the "Data" view when the source type are Datasets.

I think it's becausse of that (Show items with no data, RELATED function) 😞