Forum Discussion

Ta_Weiss's avatar
Ta_Weiss
Frequent Visitor
9 months ago
Solved

Dynamic Column Name

Hello Community, Two questions here: 1. Is there ANY way to set a dynamic name to column in a table? Example: instead of sales last month -> sales [month] that would dynamically change every mo...
Need Help
  • v-kpoloju-msft's avatar
    v-kpoloju-msft
    9 months ago

    Hi Ta_Weiss, 

    Glad to hear you managed to resolve the dynamic column name part using Field Parameters and calculated measures that’s a smart DAX-based workaround. Regarding the Power Query step error (“Value rename operations is expected”), it usually occurs when the Table.RenameColumns syntax isn’t recognized correctly because of localization (for example, needing semicolons instead of commas).

    The correct format is:

    Table.RenameColumns(PreviousStepName, {{"OldColumnName", NewNameVariable}})

    Make sure you use double braces { { } } and your regional delimiter settings match Power BI’s M language.

    For your second question on parameter snapping this behaviour is expected with list-based parameters. In the latest Power BI Desktop, the What-If parameter has been renamed to Numeric range. You can create it from Modelling → New parameter → Numeric range.

    Set your data type (Whole / Decimal), min, max, and increment values (e.g., 0 → 10 000 by 1). Click Create Power BI will add a parameter table, a slicer, and a measure. Place the slicer on your page. Users can now type or slide any numeric value freely (e.g., 500) without snapping to the nearest item.

    This is the same functionality as the old What-If parameter, just with a new name. Microsoft documentation: https://learn.microsoft.com/en-gb/power-bi/transform-model/desktop-what-if 

    Thank you for using the Microsoft Fabric Community Forum.

Ta_Weiss's avatar
Ta_Weiss
Frequent Visitor
9 months ago

Hello Zanqueta ,

I now looked at the solution and I think my problem is that my column is a metric, not an actual column. Is there any way to do that?

Zanqueta's avatar
Zanqueta
Super User
9 months ago

Are you trying change a metric name contantly? It´s doesnt make sense. Can you imagine all visual can broken. If are you using in a visual, I recommend create a dimension calendar and include the name of current month in new field.

I need more detais about you nedded, put here an example of your file and explain exactly who you want include.