Forum Discussion
Automatic Visuals by use of Configuration Table
It's a nice finger exercise. (You should read about yacc and lex). But yes, this will definitely take more than 20-30 hours. Much more.
So you are thinking about creating your own meta language ? What's the business need? Have your users asked for that?
Not directly, no. I'm converting the data from Excel into PowerQuery/PowerBI and if it was relatively readily available, it would be nice to have these calculated automatically. I have about 30 rows in my Graphics query (most likely not to increase though), so although changes to these are not very likely, I'm slightly concerned that people assume changes will be made in dashboard if changes are made in this Excel table.
That being said, this is definitely not a must, so if this requires more than 20-30 hours, then it is not worth it