Forum Discussion

vipin_jha123's avatar
vipin_jha123
Frequent Visitor
4 years ago
Solved

Sorting in Matrix report

Hi All,

 

I am new to Power BI Development. I have a simple requirment where I need to create a Matrix report.

Which I created like below which is fine.

but the one issue with above report is the highlighted filed required in a proper order.

1st should be PTD , then ELM and finally CIS .

To achive this I created one master table which hoold the code value in a proper order like below.

 

 

but this is also not helping.

 

Please do let me know which setting I am missing.

Thanks in advance.

 

Regards,

Vipin Jha

Need Help

4 Replies

    • vipin_jha123's avatar
      vipin_jha123
      Frequent Visitor
      4 years ago

      Yes This Code column I refered from Code table where I maintain the Codeid.

      But when I am dragging this CodeId column in column I am not able to see it for sorting.

      if you ok I am ok to share the report file.

    • vipin_jha123's avatar
      vipin_jha123
      Frequent Visitor
      4 years ago

      Hi,

      I am attaching below script for raw table.

      /****** Object: Table [dbo].[rawdata] Script Date: 30-11-2021 12:22:17 ******/
      SET ANSI_NULLS ON
      GO
      SET QUOTED_IDENTIFIER ON
      GO
      CREATE TABLE [dbo].[rawdata](
      [Due_Date] [varchar](100) NULL,
      [ID] [bigint] NULL,
      [Payment] [int] NULL,
      [CODE] [nvarchar](10) NULL
      ) ON [PRIMARY]
      GO
      INSERT [dbo].[rawdata] ([Due_Date], [ID], [Payment], [CODE]) VALUES (N'01-10-2021', 56536, 63, N'CIS')
      GO
      INSERT [dbo].[rawdata] ([Due_Date], [ID], [Payment], [CODE]) VALUES (N'01-10-2021', 56536, 6, N'PTD')
      GO
      INSERT [dbo].[rawdata] ([Due_Date], [ID], [Payment], [CODE]) VALUES (N'01-10-2021', 56536, 87, N'ELM')
      GO
      INSERT [dbo].[rawdata] ([Due_Date], [ID], [Payment], [CODE]) VALUES (N'01-11-2021', 56536, 63, N'CIS')
      GO
      INSERT [dbo].[rawdata] ([Due_Date], [ID], [Payment], [CODE]) VALUES (N'01-11-2021', 56536, 6, N'PTD')
      GO
      INSERT [dbo].[rawdata] ([Due_Date], [ID], [Payment], [CODE]) VALUES (N'01-11-2021', 56536, 87, N'ELM')
      GO
      INSERT [dbo].[rawdata] ([Due_Date], [ID], [Payment], [CODE]) VALUES (N'01-10-2021', 56896, 63, N'CIS')
      GO
      INSERT [dbo].[rawdata] ([Due_Date], [ID], [Payment], [CODE]) VALUES (N'01-10-2021', 56896, 6, N'PTD')
      GO
      INSERT [dbo].[rawdata] ([Due_Date], [ID], [Payment], [CODE]) VALUES (N'01-10-2021', 56896, 87, N'ELM')
      GO
      INSERT [dbo].[rawdata] ([Due_Date], [ID], [Payment], [CODE]) VALUES (N'01-11-2021', 56896, 63, N'CIS')
      GO
      INSERT [dbo].[rawdata] ([Due_Date], [ID], [Payment], [CODE]) VALUES (N'01-11-2021', 56896, 6, N'PTD')
      GO
      INSERT [dbo].[rawdata] ([Due_Date], [ID], [Payment], [CODE]) VALUES (N'01-11-2021', 56896, 87, N'ELM')
      GO

       

      I am looking for report like below

       

      highlighted column should come in correc order  like PTD , ELM and the CIS should come.

       

      Thanks,

      Vipin Jha

  • v-jingzhang's avatar
    v-jingzhang
    Community Support
    4 years ago

    Hi vipin_jha123 

     

    Sort Code column by CodeId column in code table. Create a relationship between two tables on Code columns. Put Code column from code table into the matrix. Now it should be sorted as expected. You probably missed the first sort by step. See Sort one column by another column in Power BI Desktop - Power BI | Microsoft Docs

     

    Best Regards,
    Community Support Team _ Jing
    If this post helps, please Accept it as Solution to help other members find it.