Forum Discussion

ak77's avatar
ak77
Post Patron
2 years ago
Solved

Subheaders for matrix

Hi all,

 

Not sure if this was discussed before.. so posting. please check if possible and let me know

 

i have a matrix with time measures for Returns and Market value . i need a subheader Returns and Market value displayed as above for matrix. is there a way to achieve this

 

 

Show and Tell
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    2 years ago

    Thanks for the reply from ExcelMonke , please allow me to provide another insight:
    Hi,ak77 
    Regarding the issue you raised, my solution is as follows:

    1.First I have created the following table and the column names and data are the data you have given:

    3.Create calculated column references:

     

    sam = 
VAR cc=RANDBETWEEN(0,1)
RETURN IF(cc=1,
"Returns",
"Market value ")

     

    But there are also specific MTD columns, QTD columns, and YTD columns that need to be created based on your specific data structure.


    4.Then set the visual object as follows:

    5.Here's my final result, which I hope meets your requirements

    Please find the attached pbix relevant to the case.

     

    Best Regards,

    Leroy Lu

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

     

     

     

3 Replies

  • ExcelMonke's avatar
    ExcelMonke
    Impactful Individual
    2 years ago

    Hello,

    Your question is not quite clear. Could you rephrase? 

    Based on your current explanation, this can be done by moving the column with the Returns/Market Value values into the columns section of your matrix.

    • ak77's avatar
      ak77
      Post Patron
      2 years ago

      Hi ExcelMonke 

       

      Thanks for reply.. my question was can we add a sub header to group of columns.. Returns/Market Value are the 2 subheaders for each set of MTD , QTD and YTD matrix columns 

       

      Can u please let me know.. do u have a sample to share? this wil help me a lot

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        2 years ago

        Thanks for the reply from ExcelMonke , please allow me to provide another insight:
        Hi,ak77 
        Regarding the issue you raised, my solution is as follows:

        1.First I have created the following table and the column names and data are the data you have given:

        3.Create calculated column references:

         

        sam = 
VAR cc=RANDBETWEEN(0,1)
RETURN IF(cc=1,
"Returns",
"Market value ")

         

        But there are also specific MTD columns, QTD columns, and YTD columns that need to be created based on your specific data structure.


        4.Then set the visual object as follows:

        5.Here's my final result, which I hope meets your requirements

        Please find the attached pbix relevant to the case.

         

        Best Regards,

        Leroy Lu

        If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.