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
Community Blog

Community Blog

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

Using the Community

Using the Community

Need help with the Power BI Community? Our 'Using the Community' support articles are a great place to start.

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Power Platform 2020 release wave 2 plan

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors