Forum Discussion
Solved
Dynamic sorting column in Field Parameter
Hi, I am currently building a report that contains two field parameters. The one on the left is to toggle between "Country and Product" : Parameter = { ("Country", NAMEOF('Country'[Cou...
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)}
Hi JackWren
Not exactly an answer but checking if you knew:
If you put [Parameter 2 ] in a slicer and set it to multi select, the order in which your user ticks then will define the nesting order they appear in the visual.
Yes, I know I had this at first but the end users do not want to have to select their own columns.
And I'm trying to avoid using bookmarks.