Forum Discussion
ALL and custom sorting
Hi,
One of convenient ways to check which columns are involved in the filter context is to click "Run in DAX Query View" and check the query like below.
In this case, table visualization only contains month name column and sales column. However, query contains month number column as well because month name column is sorted by the month number column.
If month name column is not sorted by month number column, month number column will not be shown in the query.
Super UserHi,
One of convenient ways to check which columns are involved in the filter context is to click "Run in DAX Query View" and check the query like below.
In this case, table visualization only contains month name column and sales column. However, query contains month number column as well because month name column is sorted by the month number column.
If month name column is not sorted by month number column, month number column will not be shown in the query.