Forum Discussion

afrutos's avatar
afrutos
Resolver I
4 years ago
Solved

Matrix

Hi everyone,
I need some help.
Is there any possibility to create a column for the Date? I couldn't find a way to do that.
When I try it it appear like this, and I just want it in one column  and it returns me one date colmn for each date.


In the mind time, I've put it like this, next to the name, but it's not the way I'd like to:

 

 

  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi afrutos ,

    I created a sample pbix file(see attachment), please check whether that is what you want.

    1. Create a matrix visual and set it as below screenshot

    2. Toggle off the option "Stepped Layout" under the menu "Row headers"

    Best Regards

4 Replies

  • afrutos ,The information you have provided is not making the problem clear to me. Can you please explain with an example.

    Appreciate your Kudos.

     

    In case you have added a date column in visual and it showing as year, qtr, month and year. You can right-click on that in the visual pane and choose the option date

     

    • afrutos's avatar
      afrutos
      Resolver I

      I would like to create somethin similar to these image

      The problem I have is that, I have a matrix; in the columns I already have some ids such as CN, CP, Ex... and in values I have the Gross value,
      What I would need is to add a date column.
      The problem is that if I take it out to the table it shows me a date column behind each id.
      And tentatively I have put the date along with the name, but that would not be the ideal way.

      thanks

       

      • Anonymous's avatar
        Anonymous
        Not applicable

        Hi afrutos ,

        I created a sample pbix file(see attachment), please check whether that is what you want.

        1. Create a matrix visual and set it as below screenshot

        2. Toggle off the option "Stepped Layout" under the menu "Row headers"

        Best Regards