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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

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
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

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

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.