Forum Discussion
Dynamic sorting column in Field Parameter
Haha, we were on the same track. I tried to also create a relationship between the two tables but I added a key column to link them instead of linking them on the order column. This seems to work in the dummy file but not in my model so I have to compare the two.
[Parameter 2 ] = {("Country", NAMEOF('Country'[Country]), 1,0),("Product", NAMEOF('Product'[Product]), 2,0),("Segment",NAMEOF(financials[Segment]),3,0),("Country ", NAMEOF('Country'[Country]),6,1),("Product ", NAMEOF('Product'[Product]), 5,1),("Segment ",NAMEOF(financials[Segment]),4,1)}
I feel like the answer is sort of:
It need refining but what I did was join the Top Slicer field to the Field Slicer
In the field slicer I dragged each field in twice
I'm sure there is a more elegant way!
Haha, we were on the same track. I tried to also create a relationship between the two tables but I added a key column to link them instead of linking them on the order column. This seems to work in the dummy file but not in my model so I have to compare the two.
Great minds, sadly I was teaching so couldn't respond faster!
I found when. I created a new column assigning the values it crashed when the data was refreshed.
Hence the method of using the name to do the join instead.
Cheers for the Kudos 😁