Dynamic measure name
Hello dear members. I need your help. I have created the following measure: Calculate(sum('table'[value]), selectedvalue( 'Version'[version]= 'table'[version])) This measure is dynamin and calculates different scenarios based on user's slicer selection. So if the selection is Actual the measure returns the actual value. If the selection is forecast it returns the forecast value. It works perfectly. I have used that measure and 2 other similar to this in a matrix. The problem is that the column name doesn't change based on the selection but it is stable and based on the measure name. How can I dynamically change the column headers?? Thank you very much
Improved table visual - dynamic column names
Hello, I have a table similar to this one I need a comparison table ("1 vs 1") with 2 columns based on Year column, using two slicers for years. So, I've created 2 tables for each slicer based on the year column using this thread: Re: Two slicer on same column FilterTBL-Base = DISTINCT('DataTable'[Year]) FilterTBL-CompareTo = DISTINCT('DataTable'[Year]) And for each "filter table" I have created the corresponding measure to know the selected value: SelectedYear-Base = SELECTEDVALUE('FilterTBL-Base'[Year]) and SelectedYear-CompareTo = SELECTEDVALUE('FilterTBL-CompareTo'[Year]) Now I am able to calculate the "base total" and the "total to compare to" in my data table using the following measures: TotalBase = SUMX(FILTER('DataTable','DataTable'[Year]=[SelectedYear-Base]),'DataTable'[Cost]) and TotalCompareTo = SUMX(FILTER('DataTable','DataTable'[Year]=[SelectedYear-CompareTo]),'DataTable'[Cost]) So the entire structure looks like this: The calculation works as expected: The only problem it bothers me, is that the final table should have the column names based on the slicer selections. In picture above TotalBase should display "FY_2010" and the TotalCompareTo should display "FY_2011". I could obtain this by manually renaming the measured used in the value field, but if the user select other options in the slicer I have to rename the fields again. As I could rename the field manually, could you consider a way to "set its name" by another measure value (ex. SelectedYear-Base)? For the moment the only "workaround" is an card visual with the same font/size as the other colum titles from the table but loosing in this way the "focus mode" for that table, sorting etc... Kind Regards, Lucian
