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

[amar306]

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?

[TomMartens]

Hey,

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

from the context menu choose "Unpivot Columns"

and there you go

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

[amar306]

Hey Tom,

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

I have the data in the below format

raw data

and need the values in the below format

required format

Thanks,

Amar

[TomMartens]

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

[amar306]

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.

[TomMartens]

Hey,

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

Hopefully this gets you started.

Regards

Tom

[amar306]

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.

matrix

Thanks,

Amar

[TomMartens · 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)

Drag the columns from your table to the proper bands

 

Finally surppress the SubTotal for each column

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.

[amar306]

Tom,

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