Dynamic X Axis Based on Slicer Selection

[kylec23]

I'm trying to have my X axis dynamically update with the selection of the slicers, in a "pecking order".

For example: If I select a year from the year slicer, axis will change to year. If I select a month from the month slicer, it will change to months within that year. If I select a day from the day slicer, it will change to days within that month with that year.

Is this possible within Excel/PowerPivot/PowerChart? I've seen easy, simple solutions in PowerBI, but sadly that is not where my program is built at the moment.

Screenshots for reference. Any help is appreciated. Thank you.

 

[kylec23]

I should probably mention that all of my charts are being generated from my Data Model which has 2 tables in it. Everything is coming from Power Pivot.

 

[kylec23]

bump