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
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!

Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Upcoming Events

Upcoming Events

Wondering what events you could join or have an event to promote yourself? Check out our Upcoming Events.

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.

Top Solution Authors
Top Kudoed Authors