[sorting order]
2 TopicsSorting X- axis based on Month-Year slicer selection
Hi Team, I am facing a chellenge to sort x-axis based on selection of filter. Image-1 Here L12M Amount is the last 12 months data from selected month. PL12M Amount is the previous last 12 months data from selected month. I want to sort the X- axis month based on selection of month in slicer, if I select Feb 2022, Feb should be at the rightmost position in place of December, remaining months need to be sorted accordingly. So, ideally if we read from right to left Feb to March at the left. Image 2 is the sorting order I want. Thank You, SSRkSolved4.5KViews0likes16CommentsSortorder in Report Builder
Hi, In Power Bi I have a FactTable of 227 project records with Start Dates starting from 1 Jan 2017 till 26 jan 2023. In PQ i added an Index Column starting from latest Start Date 26 jan 23 (Index 1) till 1 Jan 2017 (Index 227) . I am loading in Reporting Builder 5 fields from the PowerBI dataset: Year (=YEAR([Date])) ClientType (text) Location(text) Project (text) Sector(text) using the Query EVALUATE SUMMARIZECOLUMNS('ReferenceList'[Year], 'ReferenceList'[ClientType], 'ReferenceList'[Location], 'ReferenceList'[Project], 'ReferenceList'[Sector]) In Report Builder a Tablix is used and all 5 Fields are dropped in the Value box The issue: The Sorting Order is not correct. There are 5 pages and 46 lines per page. The first 3 pages is in ascending order till 1 jan 2017. But then the Project Years start with 2021 , then 2020, then 2019, then 2022, then 2022 , then 2018...later 2023 the year are all over the place. How can I force a sorting order (descending from Start dates 2023 -> 2017) either at the source data or in the Query ? Many thanks !Solved1.2KViews0likes1Comment