Forum Discussion

RichFlorida's avatar
RichFlorida
Helper V
3 years ago
Solved

Matrix with Dynamic Column Heading

For the Matrix below, I would like the headings of each column to be dynamic! I would like it to change when the month/year changes. Ex: if we are in Feb, 2023 the headings should be as illustrated ...
Need Help
  • johnyip's avatar
    johnyip
    3 years ago

    RichFlorida 

     

    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.

     

johnyip's avatar
johnyip
Solution Sage
3 years ago

It is not possible using measures directly, but if you can figure out the way of doing the calculation correctly by using CALCULATED TABLE and MEASURE and relationship, you MAY achieve that, given you can pass the ordeal of DAX.

 

You can provide a sample file, with the data structure you are using, and I can see if this is possible (without making the functioning calculated columns) to build a template with dymanic column names.