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.