Forum Discussion

Fra4's avatar
Fra4
Regular Visitor
3 years ago

Re-order table column

Hello,

I'm quite new in Power BI and this is my first post on the community.

I have a table with different columns as in the photo below.

Currently it is ordered by three different columns (1st "Articolo", 2nd "Stato" and 3rd "Scadenza") but whoever can change even by mistake the order by clicking one column.

I would like to understand if it is possible to fix that order with DAX or similar. 

 

 

Many thanks 

 

Francesca

Need Help
Tips and Tricks

1 Reply

  • Syk's avatar
    Syk
    Resident Rockstar
    3 years ago

    One simple way if you're wanting to lock in your sorting is to sort it how you want it to appear. The insert a blank rectangle shape and layer it over the column headers. This won't let anyone select the headers to change the sorting.

    You would also want to group your table and the shape.