Display all companies list with no sales according to date slicer

[edant]

Hello,

I have a table that contains the sales of companies, each sale is a different record on the table.

I also have a date slicer that I work with to see the sales between selected dates.

Now, I want to display instead only the companies which made no sales in the selected time. (of the slicer)

The problem is that whenever I change the dates in the slicer, the companies which made no sales - disappear.

Is it possible to do so?

Regards,

Edan

[DataInsights]

@edant,

You can achieve this with a measure and visual filter.

Company With No Sales = IF ( ISEMPTY ( FactTable ), 1 )

Add DimCompany[Company] to a table visual and use the above measure as a visual filter:

This solution requires a star schema:

[v-yohua-msft]

Hi, @edant 

I've created a sample table:

Then you can find the Sale in the filter next to it and filter for the companies with a Sale value of 0

If you move the slicer by date after filtering out companies that don't have sales, you can see companies that didn't have sales during a certain date period

How to Get Your Question Answered Quickly 

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data)

Best Regards

Yongkang Hua

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[edant]

Thank you for your answer.
In your solution, you declared to each date the company and the amount of sales that are being made.
I have hundreds of companies and it would be unreasonable to create for each date a list with all of the companies and the sum of the sales that they made.
Is there another way to do so without declaring the amount for each day?
I meant that if a specific date doesn't have a record of sale - it should be displayed on the list.
I have a table of dates and a table of full companies.
The third table contains records of each sale per company.
I wish to display only the companies that didn't make any sales between certain dates.

[edant]

It works only if you are not using a slicer.
If your slicer uses dates (between), the companies reduce.

[amustafa]

In your visual, right mouse click and select "Show items with no data" as shown below.