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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
amar306
Regular Visitor

Need help on values to be displayed column wise for dates.

Hi All,

 

I am new to the Power BI. I need help on displaying values column wise for dates in Table Visual. Attached images for reference. Can someone look into it and do the needful?

 

reqdata.JPGrawdata.JPG

1 ACCEPTED SOLUTION

Hey,

 

have a look a that pbix file and download it use the link from my previous post.

 

Here is some additional guidance

Make sure you are using the Matrix Visula (make sure you are using at least the July Release of Power BI Desktop)

matrix visual.png

 

Drag the columns from your table to the proper bands

matrix visual 2.png 

 

Finally surppress the SubTotal for each column

matrix visual 3.png

 

I guess this will finally enable you to create Matrix view. If this will not be the case, create a pbix file with sample data, upload the file to onedrive or dropbox and share the link to the file.



Did I answer your question? Mark my post as a solution, this will help others!

Proud to be a Super User!
I accept Kudos 😉
Hamburg, Germany

View solution in original post

8 REPLIES 8
TomMartens
Super User
Super User

Hey,

 

in the query editor mark your columns 24, 25, 26

unpivot 1.png

 

from the context menu choose "Unpivot Columns"

unpivot 2.png

 

and there you go

unpivot 3.png

 

Be aware that no rwo will be creates for " AA | 25".

 

Now rename the columns accordingly - done 🙂

 

Hopefully this is what you are looking for

 

Regards

Tom



Did I answer your question? Mark my post as a solution, this will help others!

Proud to be a Super User!
I accept Kudos 😉
Hamburg, Germany

Hey Tom,

 

Thanks for the reply. But it should be vice versa.

 

I have the data in the below format

 

raw dataraw data

and need the values in the below format

required formatrequired format

Thanks,

Amar

Hey,

 

I would just use the Matrix visual, use your Date column on column and user on rows.

 

I would not recommend to change the table layout.

 

Regards

Tom



Did I answer your question? Mark my post as a solution, this will help others!

Proud to be a Super User!
I accept Kudos 😉
Hamburg, Germany

Hi Tom,

 

The Matrix table also doesn't show the values with dates on column wise. Can you plese help me on this. It would be really grateful.

Hey,

 

not sure what I'm missing, here you will find  a little sample pbix file and here is a little screenshot

2017-10-07_19-25-52.png

 

Hopefully this gets you started.

 

Regards

Tom



Did I answer your question? Mark my post as a solution, this will help others!

Proud to be a Super User!
I accept Kudos 😉
Hamburg, Germany

Tom,

 

Appreciate your patience in replying to my mails. Thanks again. When i use the matrix table the output is as below. Seems i am missing on something.. can you please elaborate the steps...how to do this in case if i miss on something.

 

matrixmatrix

Thanks,

Amar

Hey,

 

have a look a that pbix file and download it use the link from my previous post.

 

Here is some additional guidance

Make sure you are using the Matrix Visula (make sure you are using at least the July Release of Power BI Desktop)

matrix visual.png

 

Drag the columns from your table to the proper bands

matrix visual 2.png 

 

Finally surppress the SubTotal for each column

matrix visual 3.png

 

I guess this will finally enable you to create Matrix view. If this will not be the case, create a pbix file with sample data, upload the file to onedrive or dropbox and share the link to the file.



Did I answer your question? Mark my post as a solution, this will help others!

Proud to be a Super User!
I accept Kudos 😉
Hamburg, Germany

Tom,

 

Thanks a Ton. Got it :). Missed to check it.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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