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

Hi MH3 , Following questions:Is your Hotel Name and Received date columns in same table?Is this Hotel Name based table related to any other table in your data model?Can you share screenshot of your data model with all the relationships?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

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

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

Hello Sir Anonymous I cannot see any blank option in the Filter Options of Receiving datecheck the ScreenShot, and I just want to show those hotels who had not received a file, which is indicated by this Receving date.

Hi MH3 , Can you share some sample data? Thanks,Pragati

Filtering a Visual | Microsoft Fabric Community

14 Replies

Anonymous
Not applicable
6 years ago
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
- MH3
  Helper V
  6 years ago
  Hello Sir
  Anonymous
  I cannot see any blank option in the Filter Options of Receiving date
  
  check the ScreenShot, and I just want to show those hotels who had not received a file, which is indicated by this Receving date.
  - Pragati11
    Super User
    6 years ago
    Hi MH3 ,
    Can you share some sample data?
    
    Thanks,
    Pragati
amitchandak
Super User
6 years ago
MH3 , Create a measure

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

and filter for cnt=0 // visual level filter
- MH3
  Helper V
  6 years ago
  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:
  
  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 Anonymous Pragati11
  - Pragati11
    Super User
    6 years ago
    Hi MH3 ,
    
    Following questions:
    Is your Hotel Name and Received date columns in same table?
    Is this Hotel Name based table related to any other table in your data model?
    Can you share screenshot of your data model with all the relationships?
    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

Forum Discussion

Filtering a Visual

14 Replies

Related content

Date filters for Visualization

Filters issues in visual objects

Filter on Visual Row Context

Filter on table visual

Table visual filtering