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

Filtering a Visual

Hello,

 

I have a Report in which we show Hotel Names whos files are received today with time.

 

but I want to display those hotel Names whos files are not received today, how to solve this

Annotation 2020-05-28 140519.png

please see the visualization, as I have turned on the option of Show items with no Data, but I want to show the hotels who has no Receive date.

 

Anyhelp!

 

 

14 REPLIES 14
Highlighted
Super User I
Super User I

Re: Filtering a Visual

Hi @MH3 ,

 

1. Select the chart

2. Open the filter pane on the right side

3. You will find the "ReceivingDate" filter on the Filter Pane

4. Select the "Blank" value in this filter.

 

Then you will see all the blank receiving dates in your chart.

 

Please try.

Aiolos Zhao





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Highlighted
Helper III
Helper III

Re: Filtering a Visual

Hello Sir 

@AiolosZhao 
I cannot see any blank option in the Filter Options of Receiving date

Annotation 2020-05-28 140519.png

check the ScreenShot, and I just want to show those hotels who had not received a file, which is indicated by this Receving date.

Highlighted
Community Champion
Community Champion

Re: Filtering a Visual

Hi @MH3 ,

 Can you share some sample data?

 

Thanks,

Pragati



Appreciate a Kudos! 🙂
If this helps and resolves the issue, please mark it as a Solution! 🙂
Highlighted
Helper III
Helper III

Re: Filtering a Visual

Hello, Miss @Pragati11 

I am actually developing this report for the client, but I can share you this 
Count.png
This Visualization Shows, Hotels for which the Files are received, with Received Dates,

 

and I want to show the Hotels who has not received files (No Received Dates basically).

 

like this:

Annotation 2020-05-28 140519.png

In This Visualization, I have used the Master Table of Hotel, where all the hotel names are there and I inserted the received date  which then shows received dates to the hotel names who have it, but I want to display only those hotels who have not.

 

Kya ye Ho sakta ha? 

Highlighted
Super User IV
Super User IV

Re: Filtering a Visual

@MH3 , Create a measure

cnt = count(Table[Hotel Name]) +0

 

and filter for cnt=0 // visual level filter



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!

Highlighted
Helper III
Helper III

Re: Filtering a Visual

Sir @amitchandak ,

 

Actually I have to show those hotels who have not recevied a file today, which is indicated by the Received Date,

 

As you see:
Annotation 2020-05-28 140519.png

only 4 Hotels have the Receving Date, and I want to show only those who have not and also the count for them,

 

Like as For a Todays Filter, 28th we have Received 4 Files, of 4 Hotels (names are there in the table), just like for hotels who have no received date.

anyHelp @AiolosZhao @Pragati11 

Highlighted
Community Champion
Community Champion

Re: Filtering a Visual

Hi @MH3 ,

 

Following questions:

  1. Is your Hotel Name and Received date columns in same table?
  2. Is this Hotel Name based table related to any other table in your data model?
  3. Can you share screenshot of your data model with all the relationships?
  4. The Date Filter on the page - Is it recieved Date column that you are using in the table visual below?

 

If this helps and resolves the issue, appreciate a Kudos and mark it as a Solution! 🙂

 

Thanks,

Pragati



Appreciate a Kudos! 🙂
If this helps and resolves the issue, please mark it as a Solution! 🙂
Highlighted
Helper III
Helper III

Re: Filtering a Visual

Hello @Pragati11 


1) Yes, they are in the same table, but those hotels who have Receive Dates.
2) I have used the Master Table of Hotel Names (which have all the hotel Names)

3) Sure, Annotation 2020-05-28 155925.png

4) Yes, The Date Fillter is The Received Date, Both on the Slicer and on the Table. 

Highlighted
Community Champion
Community Champion

Re: Filtering a Visual

Hi @MH3 ,

 

If your RECEIVED DATE and HOTEL NAME is coming from same table LOG HEADER, then this issue should not come.

Also you have a DATE table, if you are not using it, why it is related to the LOG HEADER table?

Similarly, what puprpose is HOTEL table serving here?

 

1st thing I would do is create all the relationships bi-directional.

Also, you date table has 2 relationships with Log Header table. Not sure why this secondary relationship is created.

 

It's hard to judge the issue without seeing your pbix file.

 

If this helps and resolves the issue, appreciate a Kudos and mark it as a Solution! 🙂

 

Thanks,

Pragati

 



Appreciate a Kudos! 🙂
If this helps and resolves the issue, please mark it as a Solution! 🙂

Helpful resources

Announcements
June 2020 Community Highlights

June 2020 Community Highlights

Featured community members, changes to the Community, and more! Read up on recent Power BI community news.

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