Formatting values for a specific measure based on calculation item

[Anonymous]

I am attempting to build a dynamic matrix that allows the user to see a variety of measures (values) for different entities (rows) based on time intelligence calculation items (columns). The difficulty I am trying to overcome is the dynamic formatting of the values. Depending on what time intelligence selection the user makes, different measures need to be formatted in different ways. 
For example, if "Current" is the Calculation Group Item selected, I need some measures to be in "$#,0,.K;($#,0,.K);-" format and others to be in "#,##0.00%;(#,##0.00%);-".  For Month-over-Month, I need dollar amount measures to stay the same format but percentages change to "#,0#pts;(#,0#pts);-". For something like Month-over-Month %, I haven't had issues since all fields just need to be percentages, and my dynamic format string works fine for that: { SELECTEDVALUE('Format Table'[Percent Variance]) }.

I wish I could create a relationship between a calculation group and other tables (I don't think that's possible), and I haven't been able to figure out a method to do this with dynamic format strings and my format table. Ideally I would be able to allow the user to select which measures they want to include in the matrix and multiple Time Intelligence selections, but after days of research trying to make this dynamic formatting work, I could live without those features. If anyone can help, thank you in advance.

My format table

Slicers and sample of Matrix. "Metric" is the values currently as field parameters, but I'm fine with ditching field parameters and placing all the individual measures in the Values if needed.

[lbendlin]

Have your users asked for that functionality?  Would it be better to enable "Personalize Visuals" and teach them how to use it?

[Anonymous]

This is part of a project to convert and condense a large non-PBI report into Power BI.  I'm relatively new to Power BI, but I was hoping that if I dug into it enough, especially after learning about new recent features like dynamic format strings, calculation groups, etc, that creating this kind of dynamic matrix would be very doable with some know-how. But now I'm not sure if I'm overthinking things, or if my goal just isn't a reasonable one for what Power BI is currently capable of.

[lbendlin]

Read about "fighting the API".  Don't try to coerce Power BI into something it is not. Embrace its features and capabilities.