Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Slicer not working with multiple tables

hello

 

i am new in powerbi . i tried to connect two tables with one slicer using date. the problem is when i try to use the date slicer it works only for the first table. but the second does not work .  i created a relationship between both tables. but the slicer is not working for both 

 

the relationship which i created ( code for both tables ) 

 

first table 

 

codedatename
77701.01.2021john
88802.02.2021jason
99901.01.2021petter

 

 

 

second table

 

 

codedatename
77701.01.2021lamar
88802.02.2021ice
99901.01.2021hot

 

 

 

 

so what should i do to make it work ( i dont know anything about M Language )

 

 

Need Help
Tips and Tricks

5 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Anonymous it sounds like your model/relationships are not configured correctly.  Ideally, you would have a central "Date Table" which is related to the date columns in each table.

    Could you post a screenshot of the relationships you currently have?

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Anonymous 

       

      the problem that when i create the relation using the date . it will work only in slicer. but when i click at the applepie for each table it will not work

       

      i attached the screenshot 

       

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    hello guys

     

    any update?

    • v-easonf-msft's avatar
      v-easonf-msft
      Icon for Community Support rankCommunity Support
      5 years ago

      Hi.  Anonymous 

      It is not very clear. From your current screenshot, you are establishing the relationship between the tables based on the field "Code" rather than "Date".

      If you want to filter the data by date, it is recommended to establish a relationship based on "Date".

      If your model has a date table, it is recommended to create a one-to-many relationship as follows, and use the dates in the calendar table  as the slicer.

       

      Best Regards,
      Community Support Team _ Eason

       

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    v-easonf-msft Anonymous 

     

    thank you for your support the slicer is working fine because i changed the relationship between two tables to date instate of card type. but i face another issue.

     

    i am having two pies . each by is represinting a table. when i click on any pie card wich include ( Visa, master, jcb ) the other pie does not change.  before two pies was working fine because the relationship between tables was ( card code , card code ) but when i change the relationship to date the pies not working.

     

    my tables data as below

     

     

    table 1

    *  date

    *  card code

    *  transaction amount

    *  card company ( Visa , master, Jcb )

     

    table 2

    *  date

    *  card code

    *  transaction amount

    *  card company ( Visa , master, Jcb )

     

     

     

    any advice to make slicer and the pies works ?