This is not order of months, this is alphabetical order. For example if you look at above chart you can see that months ordered from April to September. Problem happens when you want a Text field to be ordered based on something different than the value of the field. This is the normal behaviour, a field will be ordered by values in the field itself. If you sort it based on Sales Amount it is obviously showing you from biggest value to the lowest or reverse. You can choose to sort based on fields that used in this visual, which can be either SalesAmount, or EnglishMonthName. If you click on the three dot button on top right hand side of the chart you can see the sorting option for this visual. Create a visualization (Area Chart for example) with SalesAmount as Values, and EnglishMonthName as Axis. Check the relationship between these tables to be only based on an active relationship between OrderDateKey in the FactInternetSales and DateKey in the DimDate. Let’s look at it through an example Ĭreate a New Power BI Desktop file, and Get Data from AdventureWorksDW, from DimDate, and FactInternetSales Tables. It means if the field is numeric it will be ordered based on the number, if it is text it will be ordered alphabetically. By Default a field’s data is sorted by that field it self.
0 kommentar(er)
