Two Tables Linked To One Date Table. Two Things I’m Noticing When Trying to Filter

  • Two Tables Linked To One Date Table. Two Things I’m Noticing When Trying to Filter

    Posted by DSC Communities on November 22, 2019 at 1:12 pm
    • Christian ArltX

      Member

      November 22, 2019 at 1:12 PM

      I have two tables linked to one date table. When I go into Power BI and create two charts for each table… and use the same fields from the shared date table so I can drill down (Year/Month/Day).

      I then turn on the drill down feature for both charts… but when I click a year on one of the charts it drills down to the months (of that year) while the other chart just shows the Year alone, but doesn’t drill down to the months too.Ā 

      It happens when I do it the other way around too.

      How do I make it go to the months for both when I click on a year?

      ——————————
      Beau Arlt
      Business Analyst
      Holland MI
      989-400-7812
      ——————————

    • Hasham Niaz

      Member

      November 22, 2019 at 6:33 PM

      Hi !

      Please check cross-highlighting & cross-filtering setting in Power BI Desktop file, also check Edit interactions between 2 visuals.Ā 

      If possible please share your .pbix file with sample data as we are not sure how you model these tables.

      Regards,

      ——————————
      Hasham Bin Niaz
      Director Data & Analytics
      Karachi, Pakistan
      ——————————
      ——————————————-

    • Lorenzo Vercellati

      Member

      November 25, 2019 at 5:10 AM

      Hi,
      I think you can’t do that.
      On different visuals you can manage cross-filtering not something like cross-drilling down.
      You can build something like you want using bookmarks and buttons.

      Regards
      Lorenzo

      ——————————
      Lorenzo Vercellati
      PowerBI Solution Architect
      SolidQ
      Milan
      3382819866
      ——————————
      ——————————————-

    • Christopher Majka

      Member

      November 25, 2019 at 8:42 AM

      For the chart just showing years, does it only contain a year field in the fact table? If so, then you won’t be able to get to the month granularity. You can perhaps create a new column that contains month in that table, but i’m not sure what the rest of your fields look like in that table.

      ——————————
      christopher majka
      Manager, Business Intelligence
      4018682000
      ——————————
      ——————————————-

    DSC Communities replied 6 years, 4 months ago 1 Member · 0 Replies
  • 0 Replies

Sorry, there were no replies found.

The discussion ‘Two Tables Linked To One Date Table. Two Things I’m Noticing When Trying to Filter’ is closed to new replies.

Start of Discussion
0 of 0 replies June 2018
Now

Welcome to our new site!

Here you will find a wealth of information created for peopleĀ  that are on a mission to redefine business models with cloud techinologies, AI, automation, low code / no code applications, data, security & more to compete in the Acceleration Economy!