Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
BI-Titan
Frequent Visitor

Trying to show same month last year column next to the latest month column in Matrix

Hi,
I am trying to show the previous year's same month column next to the latest month column in a matrix. Currently I only have 2 moths of data in PowerBI before I load all the data in after I finish the visualization and dax. The data will update monthly with a new month being introduced.
This is what I am trying to make it look like. Any help would be appreciated.

BITitan_0-1674832477172.png

 

2 REPLIES 2
amitchandak
Super User
Super User

@BI-Titan ,

 

You need have column like these in you date tbale

 

Month Year = FORMAT([Date],"mmm\'yy")
Month Year sort = FORMAT([Date],"mmYYYY")

 

Mark the month year sort column as the sort column of the month year and use that in visual

 

The sort column will give both Oct together

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

@amitchandak ,
Thank you this helps i just have one tweak I need some help with. 

BITitan_0-1675802303613.png

I need the the last year's month next to latest month of this year on the far right side instead of on the left like shown in the picture. In this example I need Jan 23 coming after Dec 22 with Jan 22 next to it

 

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.