cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
vipin_jha123
Frequent Visitor

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.

vipin_jha123_0-1638184286103.png

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.

 

vipin_jha123_1-1638184400760.png

 

but this is also not helping.

 

Please do let me know which setting I am missing.

Thanks in advance.

 

Regards,

Vipin Jha

1 ACCEPTED SOLUTION
v-jingzhang
Community Support
Community Support

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

21120305.jpg

 

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

View solution in original post

4 REPLIES 4
v-jingzhang
Community Support
Community Support

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

21120305.jpg

 

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

View solution in original post

amitchandak
Super User
Super User

@vipin_jha123 , Have marked Codeid as he sort column for code ?

 

 

and is code is getting used from this Table ?


PowerBI Abstract Thesis Episode 6: How to Create Sort Column and Solve Related Errors:
https://www.youtube.com/watch?v=KK1zu4MBb-c

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!! !!
Dashboard of My Blogs !! Connect on Linkedin
Want To Learn Power BI
Learn Power BI Beginners !! Advance Power BI Concepts !! Power BI For Tableau User !! Learn Power BI in Hindi !!
Proud to be a Super User!

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

vipin_jha123_0-1638255243159.png

 

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

 

Thanks,

Vipin Jha

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.

Helpful resources

Announcements
2022 Release Wave 1 760x460.png

2022 Release Wave 1 Plan

Power Platform release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.

Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

Jan 2022 Dev Camp 768x460 copy.png

Power BI Dev Camp- January 27th, 2022

Mark your calendars and join us for our next Power BI Dev Camp!

Top Solution Authors