Forum Discussion

Zaky's avatar
Zaky
Helper IV
5 years ago

Need Help - Month Filter

Hi,

 

I have 2 separated data from sheet July 2020 and Aug 2020.
With these data I want the table to visualize the information based on the selected month filter.
For example if I choose one of the reported date, the information in the table will change accoding to the selected month.

How can I make this happend?

 

Expected visual like below

 

Data at this link https://1drv.ms/u/s!AqKwe2kf8OBIZ2FrWmnYkpafICE?e=wQKOXR

Need Help

3 Replies

  • darentengmfs's avatar
    darentengmfs
    Post Prodigy
    5 years ago

    Zaky 

     

    Create a date table and create the relationship between Table A to DateTable, and Table B to DateTable. Then, use the fields in the date table as your slicer.

    • Zaky's avatar
      Zaky
      Helper IV
      5 years ago

      darentengmfs 

       

      thank you for reply.

      Actually I already created the relationship like you mentioned, but the table visual just blank when i filter for the month of Aug.

      Maybe you can help create pbix visual based on data that i shared at the link. Maybe i missed out something.

       

      Thanks

       

  • CNENFRNL's avatar
    CNENFRNL
    Community Champion
    5 years ago

    Hi, Zaky , it's fairly easy to implement it, all you need to do is just to append your reports together and then drag "Date Reported" column to slicer.

    Pls refer to this file for details.