dynamic column entry or workaround

Hi Pikachu-Power ,

We could only add columns in X axis. As far as I know, Power BI doesn't support us to create a dynamic column based on filter. I suggest you to add Start Plan, Start FC into the data model and then calculate the measure for all of them. Then you can filter by X axis appear or disappear.

My Sample:

New_Table:

New_Table = 
DATATABLE (
    "Column 1", STRING,
    "Column 2 Order", INTEGER,
    "Column 3", STRING,
    "Column 4", STRING,
    {
        { "Start", 1, "Start Plan", "Plan" },
        { "Middle", 2, "Middle Plan", "Plan" },
        { "End", 3, "End Plan", "Plan" },
        { "Start", 4, "Start FC", "FC" },
        { "Middle", 5, "Middle FC", "FC" },
        { "End", 6, "End FC", "FC" }
    }
)

Measure:

Measure = 
VAR _SUM = CALCULATE(SUM('Table'[Value]),FILTER('Table', 'Table'[Column1] = MAX(New_Table[Column 1])&&'Table'[Column4] = MAX(New_Table[Column 4])))
RETURN
IF(ISFILTERED(Column4[Column 4]),_SUM,BLANK())

When I select Plan in slicer it will show all plan in axis.

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.