Dynamic Dimension

Hi Yuliana 

Thank you for your feedback.

I saw the examples you mentioned. They are complex and require you to rework the logic every time you add new dimensions to the dimension table. There must be an easier way.

In Qlik I a can link a variable to the standalone dimension table that might hold sixty possible dimensions. The variable will return the dimension value selected, and that value will pop on the X-axis if I use the under mention syntax.

I am aware of the fact that this is Power BI, and that Power BI does not have global variables, but are looking for a simple way to make a DAX value “pop” on the X-axis of a chart or table.

Variable (Qlik):

           vDynamic_Dimension =MaxString(Dimension)

Syntax for Dynamic Dimension (Qlik):

           =[$(='$(vDynamic_Dimension )')]

v-yulgu-msft Is there a feature page for this functionality that we can vote on?

The walk through here is helpful, as v-yulgu-msft points out: http://www.leanx.eu/tutorials/dynamic-dimensions-in-power-bi

However, the author mentions that creating a join table is a critical step but fails to instruct readers how to make one. The logic is described adequately: a unique combination for each unique ID + dimension value. But how do I generate that table in the query editor?