Once you become the "dashboard guy" at your organization, it's game over - that is all you'll be doing - there is literally a never-ending demand of dashboards in any org that works with lots of data, and those dashboards will grow into full-blown apps, sooner or later.
Your tone implies that you think that is a bad thing. But if you have become the dashboard guy, you must have been good at it... which typically only happens if you enjoy it. And being "bogged down" in stable work that you enjoy is most people's goal.
It depends on what you want to do. If you're a regular analyst or data scientist, working on reports, dashboards, tooling, R&D, etc. - most in those roles (me included) have many balls in the air.
As far as the technical hierarchy goes, these organizations are usually somewhat like this:
1. Excel (everyone knows excel)
2. PowerBI / Tableau / etc. (few know these, because they are either a bit more complex than Excel, or a more simple than R/Python/Julia/etc. + your favorite viz and analysis packages. The people that only use Excel don't bother learning it, the guys only programming won't either)
3. Programming (some know these things)
If you love working with either 1) or 3), then becoming the Tableau/Power BI expert can be a drag.
