Forum Discussion
Matrix with Dynamic Column Heading
Please check my sample here at the link. It is hard to explain in words detailedly, but I can tell what have I done concisely.
1. Create a table that contains all the possible dynamic values you wish to see (I created the table 'Dynamic header')2. Create a calculated column in your raw data table, which is used to make a relationship between the raw data and the table in step 1 (For me, it is a single directional relationship from 'Dynamic header' to 'Earthquakes')
3. Create a measure for the table in step 1, aiming to clone the exact value of the dynamic title column.
4. write yor measure. Yes, write it all in a single measure, unlike what you have done previously (different things in different measures). This is why I said it is an ordeal.
I have improvised something like this on my own and I still believe that is an ordeal if your measures to be used are complex.
https://drive.google.com/file/d/16zun85AxSoGLqAVjum9knrqVetUnaFGN/view?usp=share_link
I hope you can make it if this dynamic title requirement is really necessary.
Please check my sample here at the link. It is hard to explain in words detailedly, but I can tell what have I done concisely.
1. Create a table that contains all the possible dynamic values you wish to see (I created the table 'Dynamic header')2. Create a calculated column in your raw data table, which is used to make a relationship between the raw data and the table in step 1 (For me, it is a single directional relationship from 'Dynamic header' to 'Earthquakes')
3. Create a measure for the table in step 1, aiming to clone the exact value of the dynamic title column.
4. write yor measure. Yes, write it all in a single measure, unlike what you have done previously (different things in different measures). This is why I said it is an ordeal.
I have improvised something like this on my own and I still believe that is an ordeal if your measures to be used are complex.
https://drive.google.com/file/d/16zun85AxSoGLqAVjum9knrqVetUnaFGN/view?usp=share_link
I hope you can make it if this dynamic title requirement is really necessary.
Hi RichFlorida , Welcome. Hope the sample file can help you in understanding the creative way to make the measures' name dynamic, and please accept that as the solution so others can look for assistance from your thread.