Forum Discussion

navpienaar's avatar
navpienaar
Regular Visitor
8 years ago

Dynamic Dimension

I want to create a Dynamic Dimension by creating a “global variable” getting a dimension from an island table (Dimension = Customer, Item, Salesperson, Region …)   DAX Measure or Column:      vDyna...
Need Help
navpienaar's avatar
navpienaar
Regular Visitor
8 years ago

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 )')]