Forum Discussion

JackWren's avatar
JackWren
Icon for Helper II rankHelper II
2 years ago
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...
Need Help
Tips and Tricks
  • JackWren's avatar
    JackWren
    2 years ago

    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)
    }
SamWiseOwl's avatar
SamWiseOwl
Icon for Super User rankSuper User
2 years ago

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!

JackWren's avatar
JackWren
Icon for Helper II rankHelper II
2 years ago

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)
}