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

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

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
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.