Forum Discussion
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...
Hi navpienaar,
You want to dynamically change dimensions displayed on X-axis depend on slicer selection, right?
If so, here are two samples for your reference:
Dynamic dimensions in Power BI
Best regards,
Yuliana Gu
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?