Lucian's avatar
Lucian
Responsive Resident
6 years ago
Status:
New

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

No CommentsBe the first to comment