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?

5 REPLIES 5
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

 

Highlighted
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)