使用切片器功率bi按周和一周中的某一天汇总表

您需要一个单独的图表表。使用以下内容创建新的计算表:

Dim WeekDay = DATATABLE(
    "weekday num", INTEGER, "weekday str", STRING,
    {
      { 1, "Sun" },
      { 2, "Mon" },
      { 3, "Tue" },
      { 4, "Wed" },
      { 5, "Thu" },
      { 6, "Fri" },
      { 7, "Sat" }
    }
  )

创建表格后,单击 weekday str 然后在“列工具”中,选择 Sort by column 并选择 weekday num

创建两个新度量值:

Avg Sales = AVERAGE(sales_base[sales])

Avg by Weekday = COALESCE([Avg Sales]('sales_base'[week_day] = SELECTEDVALUE('Dim WeekDay'[weekday num])), 0)

现在更新您的图表以使用:

X-Axis: 'Dim WeekDay'[weekday num] OR 'Dim WeekDay'[weekday str]
Y-Axis: [Avg by Weekday]