Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[Christian ArltX]

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]

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]

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]

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
——————————
——————————————-