Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

Sorting by Spend column in a dynamic metric setting

Hello,    One of the request faced by my stakeholder is wanting the ability to select only certain columns to show in a table visual. To accomodate this need, I have used DAX to create a metrics ta...
Need Help
  • Thejeswar's avatar
    Thejeswar
    1 year ago

    HI Anonymous ,

    I don't think you can sort your columns individually using this approach. Seeing your report, I understood that the sort happens based on the total column. One more thing is you are keeping it as text, so the sort also is going to happen based on character. i.e. 85 will be greater than 600.

     

    Instead you can go ahead with the approach of using Field Parameters for this.

     

    Refer the Page 1 in the file attached here

    Regards,

Thejeswar's avatar
Thejeswar
Icon for Super User rankSuper User
1 year ago

HI Anonymous ,

I don't think you can sort your columns individually using this approach. Seeing your report, I understood that the sort happens based on the total column. One more thing is you are keeping it as text, so the sort also is going to happen based on character. i.e. 85 will be greater than 600.

 

Instead you can go ahead with the approach of using Field Parameters for this.

 

Refer the Page 1 in the file attached here

Regards,

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi Thejeswar, this works but I can't seem to replicate your table MeasureSelector using NAMEOF. How is this done please. Thanks.