Forum Discussion

MH3's avatar
MH3
Helper V
6 years ago

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 ...
Data Protection
Need Help
Show and Tell
Tips and Tricks
Pragati11's avatar
Pragati11
Super User
6 years ago

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

MH3's avatar
MH3
Helper V
6 years ago

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, 

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

  • Pragati11's avatar
    Pragati11
    Super User
    6 years ago

    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

     

    • MH3's avatar
      MH3
      Helper V
      6 years ago

      Pragati11
      I'll explain it to you Everything step by step

      1)  I had created the Date Table just for case, but then my senior said in Log Header Table there are dates which we can use it, but I linked my Date Column with the Received Date colum in Log Header.

       

      2) The Hotel Table contains, Master Table which have all the Hotels Names

       

      3) and there is a Linkage of Hotel Names in Log Header Table, which shows which hotels have Received a file (indicated by Received Date Column).

       

      My Problem is I have to show those hotels which have no Received Dates Against them,

      like this: 


      In this all hotels are showing, but the received dates are empty on those which have not received a file.

       

      So, I have put the Hotel Name Column (from Hotel Table) because from that I can show those hotels who haven't received a file yet as respect to the slicer.

      If you still got questions ask me this help you to solve my problem.

       

      Thanks!

      • Pragati11's avatar
        Pragati11
        Super User
        6 years ago

        Hi MH3 ,

         

        Just mentioning this again, can you share your pbix file?

         

        If not try following:

        1. Remove relationship between DATE and LOG HEADER tables
        2. Make relationship between HOTEL and LOG HEADER tables bi-directional.

        Then see what happens. 

        This issue is something, I can't provide a solution until I can see it on pbix file.

         

        Try above and see if this helps.

         

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

         

        Thanks,

        Pragati