Semantic Model Data Source in Power bi is not getting the "Sort by column" in the Model View

Question

I try to sort the month name by the number of the month inside the semantic model but its not reflacting in my power bi report??&nbsp;&nbsp;

anonymous · Accepted Answer

Thank you for your detailed response and efforts, Yang.I appreciate the tests you've conducted, and I understand the display issue on the Power BI Desktop when linked to the semantic model from the service. However, I've noticed that when using a Slicer, the sorting doesn't work as intended, even though it functioned correctly in earlier versions of Power BI.To work around this, I am currently prefixing the month names with their respective numbers (e.g., "01-January", "02-February"). This method ensures the slicer sorts the months correctly. I thought it might be useful to mention this workaround in case others face a similar issue and are looking for a temporary solution.&nbsp;from pyspark.sql import SparkSession
from pyspark.sql.functions import format_string, udf, concat_ws, date_format,col, trim, substring_index, regexp_replace,regexp_extract, when, expr, ltrim, rtrim, date_format, dayofmonth, weekofyear, month, quarter, year
from pyspark.sql.types import StringType

def translate_month(month_number):
    months_in_arabic = {
        1: "January", 2: "February", 3: "March", 4: "April",
        5: "May", 6: "June", 7: "July", 8: "August",
        9: "September", 10: "October", 11: "November", 12: "December"
    }
    return months_in_arabic.get(month_number, "")

month_udf = udf(translate_month, StringType())

# Define transformations
df_new_cases = df_cases.select(
concat_ws(" ", format_string("%02d", month("date_opened")), month_udf(month("date_opened"))).alias("MonthName"),,,,,,
)&nbsp;&nbsp;Best regards, Asaad AlSharif

Forum Discussion

2 Replies

Related content