Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I am using a SQL Server connection in VS and importing tables. In my table, I have a Date column and then another column that is extracting the Month_Name of the Date column.
Example
Date Month_Name
01/05/2021 January
03/07/2021 March
08/21/2021 August
I used the following script in Advanced Editor in VS to do this:
#"Extracted Month Name" = Table.TransformColumns(#"Filtered Rows", {{"Month_Name", each Date.MonthName(_), type text}})
Then when I go to by Power BI dashboard and display the Month_Name in a table, it is not ordering by date, it's ordering alphabetically.
(August, January, March)
How do I get this column to order by date?
(Can't edit the column in PBI since I'm using a VS connector)
@Anonymous Hmm, well, you need to use a Sort By column that is the numeric month number.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
41 | |
21 | |
21 | |
14 | |
13 |
User | Count |
---|---|
43 | |
36 | |
33 | |
18 | |
18 |