Field Parameter with 2 fields not displaying in X axis

[kahn_ohara]

I have the following field parameter that allows the user to toggle between displaying calendar year and fiscal year. I also have a slicer on value4 = Calendar year or Fiscal year.

Parameter = {

    ("Year", NAMEOF('Date'[Year]), 0,"Calendar year"),

    ("Month", NAMEOF('Date'[Month]), 1, "Calendar year"),

    ("FY", NAMEOF('Date'[FY]), 2, "Fiscal year"),

    ("Month (FY sorted)", NAMEOF('Date'[Month (FY sorted)]), 3, "Fiscal year")

}

Using a table visual, when I select "Calendar year" in the slicer both year and month are shown. However, for the stacked bar chart only year is shown and not month. Does anyone know if there's any way to fix this?

If the field parameter were working correctly the stacked barchart would display as below.

[Idrissshatila · Accepted solution]

Hello @kahn_ohara ,

you need to drill down in the first screenshot, as you can see the second one is drilled down.

[kahn_ohara · Accepted solution]

I got it. Have to click on x axis then can click expand to next level.

[Idrissshatila · Accepted solution]

Hello @kahn_ohara ,

you need to drill down in the first screenshot, as you can see the second one is drilled down.