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

Learn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register now

Reply
afrutos
Resolver I
Resolver I

Matrix

Hi everyone,
I need some help.
Is there any possibility to create a column for the Date? I couldn't find a way to do that.
When I try it it appear like this, and I just want it in one column  and it returns me one date colmn for each date.

afrutos_0-1641314989151.png
In the mind time, I've put it like this, next to the name, but it's not the way I'd like to:

afrutos_1-1641315090650.png

 

 

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Hi @afrutos ,

I created a sample pbix file(see attachment), please check whether that is what you want.

1. Create a matrix visual and set it as below screenshot

yingyinr_1-1641544297660.png

2. Toggle off the option "Stepped Layout" under the menu "Row headers"

yingyinr_0-1641544168392.png

Best Regards

View solution in original post

4 REPLIES 4
afrutos
Resolver I
Resolver I

 Hi, can anybody help me?

amitchandak
Super User
Super User

@afrutos ,The information you have provided is not making the problem clear to me. Can you please explain with an example.

Appreciate your Kudos.

 

In case you have added a date column in visual and it showing as year, qtr, month and year. You can right-click on that in the visual pane and choose the option date

 

Date as Date or Hirrarchy.png

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

afrutos_0-1641318127148.png

I would like to create somethin similar to these image

The problem I have is that, I have a matrix; in the columns I already have some ids such as CN, CP, Ex... and in values I have the Gross value,
What I would need is to add a date column.
The problem is that if I take it out to the table it shows me a date column behind each id.
And tentatively I have put the date along with the name, but that would not be the ideal way.

thanks

 

Anonymous
Not applicable

Hi @afrutos ,

I created a sample pbix file(see attachment), please check whether that is what you want.

1. Create a matrix visual and set it as below screenshot

yingyinr_1-1641544297660.png

2. Toggle off the option "Stepped Layout" under the menu "Row headers"

yingyinr_0-1641544168392.png

Best Regards

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.

February Power BI Update Carousel

Power BI Monthly Update - February 2026

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

Users online (8,075)