Forum Discussion

Icon for Helper I rank

Helper I

2 years ago

Dynamic column names from measure

I would like to create a table where the column names are the years. Currently I have two drop down slicers to select the years to compare (ie. Year 1, Year 2). I can correctly create the table b...

Icon for Solution Sage rank

Solution Sage

2 years ago

zervino , Look into field parameters if that could help in this situation.

Material on field parameter:

Power BI Field Parameters — A Quick way for Dynamic Visuals: https://amitchandak.medium.com/power-bi-field-parameters-a-quick-way-for-dynamic-visuals-fc4095ae9afd
Power BI Field Parameters- Measure Slicer and Axis/Dimension slicer: https://youtu.be/lqF3Wa1FllE
Switch TOPN with Field Parameters: https://amitchandak.medium.com/switch-topn-with-field-parameters-299a0ae3725f
Field Parameters- Conditional Formatting
: https://amitchandak.medium.com/field-parameters-conditional-formatting-517aacc23fdf

Thank You