Forum Discussion
Helper IDynamic 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 below, but the column headers show Year 1 and Year 2. Instead I would like to show the selected year numbers (which are stored in other measures: year_1, year_2)
Is this possible?
1 Reply
ChiragGarg2512Solution Sage
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-517aacc23fdfThank You