cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper III
Helper III

Showing Data with No Dates Associated with it

Hello Everyone,

 

This is my 2nd Post, I'll try to explain my problem which I am facing more better in this.

 

First Look at my Model:
Model_1.jpg

The Date Table: Date Column is Linked with Log Header Table: Receving Date Column (Active RelationShip),

The Hotel Table (Master Table of all Hotel Names): Hotel Code Column is linked with Log Header Table: Hotel Code Column,

The Log Details Table: ID Column is Linked with Log Header Table: ID Column.


Now, I have this Main Report:
Visual_2.jpg

The Date Slicer is Set for Last Two Days,


The Visualization on Left
: it shows those hotel Names who had received a file in that date filter, like on 28th May, 4 files were recevied from client (XML files) and the names are shown in this table visualization.

 

The Visualization on Right:  I want to show only those hotels who had not received a file in that date filter, I have used Hotel Name Column from Hotel Table (because in this table all hotel names are listed, though which I can see those hotel who has no receive date associated with them, Like Hotel Grindelwald and Hotel Klosters had no Receive Dates associated with it) and Receving Date Column from Log Header Table.

 

is there any way to achieve that, I only want to show those hotels who had no received dates associated with them, and also a count of those in my multi card on top of these table visualizations.

 

Need Help in this.

1 REPLY 1
Highlighted
Super User IV
Super User IV

Re: Showing Data with No Dates Associated with it

@MH3 , I remember a similar problem was posted.  Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
My Recent Blog -Week is not so Weak Connect on Linkedin

Proud to be a Super User!

Helpful resources

Announcements
August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

July 2020 Community Highlights

July 2020 Community Highlights

Learn about the exciting things that happened in July.

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

We are thrilled to announce we will begin running a monthly webinar series named Power BI Dev Camp.

Power BI Desktop August 2020 Update

Power BI Desktop August 2020 Update

We have great updates this month! Click the link for the video with more info.

Top Solution Authors
Top Kudoed Authors