Customizing X Access

[kkalyanrr]

Hello Team,

I'm trying to potrait a chart with Date on X Axis and Year and Month as Filters.
My requirement is,

When I click on Year X Axis should be on Months as shown in one chart..

When I click on Month X axis should be on Weeks as shown in second chart..

Please help me out..

Thanks,

Kalyan..

[v-sihou-msft]

@kkalyanrr

No, it's not possible to dynamically populate data fields on X-axis based on the selection in slicer. And since a week may cross two months, we can't build the hierarchy like "Month->Week" either. You should still create multiple visuals for different granularity.

Regards,

[rajulshah]

I have a technique on how to do it.

If you're still interested , feel free to ping.

Thanks!

[kkalyanrr]

@rajulshah

Please let me know how can we get this in chart..