cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
wsabey Regular Visitor
Regular Visitor

Crosstab report - module 2, topic 8

How can we place years across the columns as in the beginning of this video? 

I do not see the row and column choices as the instructors user interface shows.

 

the year column in Date is a whole number - is this a factor in not showing this table format?

6 REPLIES 6
wsabey Regular Visitor
Regular Visitor

Re: Crosstab report - module 2, topic 8

ah, after looking for a dax function to convert whole number year, the easier way is to grab the year off date.

in edit queries of the date table:

DateYear.PNG

on the report, select the Matrix visualizer - the rows, columns are available

Matrix.PNG

 

tishwakefield Frequent Visitor
Frequent Visitor

Re: Crosstab report - module 2, topic 8

I accidentally discovered that the crosstab report is a matrix and not a table.  The matrix icon is next to the table icon in the Visualizations panel on the upper right.  Since they are next to each other and not particularly distinctive, it is easy to make a mistake.  The report we are trying to build looks very much like a table to me.  Very confusing.  Screenshot attached.

 

 CrosstabMod2Topic8.JPG

tishwakefield Frequent Visitor
Frequent Visitor

Re: Crosstab report - module 2, topic 8

Basic transformations for date columns formatted as 'text' to date columns formatted as 'date' can be found in Module 1, Basic Transformations: 

 

https://courses.edx.org/courses/course-v1:Microsoft+DAT207x+5T2016/courseware/1f6e7b08f1154b2c8f3ee4...

arojash Frequent Visitor
Frequent Visitor

Re: Crosstab report - module 2, topic 8

Thanks, your image and commnet was a great help. Smiley Happy

ydaoud Frequent Visitor
Frequent Visitor

Re: Crosstab report - module 2, topic 8

Yes, I made it.

 

Thanks guys Smiley Happy)

Highlighted
Ragz_77 Frequent Visitor
Frequent Visitor

Re: Crosstab report - module 2, topic 8

When I tried this, I got an error saying 'The data value must contain Date component'..? Help needed !!

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 42 members 838 guests
Please welcome our newest community members: