Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
2 years ago

Custom Matrix Headers

Hello

I have the following table and matrix

As you can see, the matrix is correct but I would like to go further and make that instead of the headers they have that name (orders shipped, total orders...), add the date that is being selected in the segmentation, in this case Orders sent on 01/01/24. So far I've got it, I've basically added a new column by combining section + date

The problem comes when the section is "Orders received" and I want it to be "Orders received in January to serve in the same month". Sure, the custom column doesn't work for me the way I have it anymore since I just want to add that chunk to that row and not the others.

It's possible?

Thank you.

3 Replies

  • Syndicate_Admin's avatar
    Syndicate_Admin
    Administrator
    2 years ago

    Hello @apenaranda ,
    There's a chance you can share a sample of the data in a table to get a better understanding of what you're working with and what you want to achieve.
    I think the solution can be achieved with in IF-statment in your calculated column (in this case Custom Column) in Power Query as long as the Orders received section is also part of the data.

    Best regards
    Alan Fredes

    • Syndicate_Admin's avatar
      Syndicate_Admin
      Administrator
      2 years ago

      In the end, if I managed to do it through an if

      Titulo = IF(Tabla_pruebas_cabeceras[seccion]="total pedidos",CONCATENATE(Tabla_pruebas_cabeceras[seccion],CONCATENATE(" ",Tabla_pruebas_cabeceras[date])),IF(Tabla_pruebas_cabeceras[seccion]="pedidos enviados",CONCATENATE(Tabla_pruebas_cabeceras[seccion],CONCATENATE(" en ",CONCATENATE(Tabla_pruebas_cabeceras[date]," para servir en el mismo mes")))))

      Thanks a lot!

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi Syndicate_Admin ,

     

    Based on the information you provided, could you give a more detailed explanation. For example, is your delivery time a new column or is it added below the Date; are there two forms according to your description and if so what does the other form probably look like.


    A better description of the problem encountered and what you want to accomplish will allow us to solve your problem faster and better.

     

    How to Get Your Question Answered Quickly - Microsoft Fabric Community

    If it does not help, please provide more details with your desired out put and pbix file without privacy information.

     

    Best Regards,

    Yifan Wang

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