Forum Discussion

Dicken's avatar
Dicken
Post Prodigy
1 year ago
Solved

Stop nesting in Matrix visual

Hi, can someone tell if   / how I can  stop nesting of month within year of a matrix ;   my calendar is ;  CalTable = VAR mindate = MIN(Table1[Date]) VAR maxdate = MAX(Table1[Date]) RETURN ...
Need Help
  • Dicken's avatar
    Dicken
    1 year ago

    The best I've come up with is to go to layout  style minimal , layout tablular then 
    go to rows and toggle off the expand colapse . 

hnguy71's avatar
hnguy71
Super User
1 year ago

Hi Dicken ,

You would create a new column for the Month and Year together, like so:

CalTable =
VAR mindate = MIN(Table1[Date])
VAR maxdate = MAX(Table1[Date])
RETURN
ADDCOLUMNS(
CALENDAR( mindate, maxdate )  ,
"Year", YEAR([Date]) ,
"Sort", MONTH([Date]) ,
"Month", FORMAT([Date],"MMM"),
"Period", FORMAT([Date], "MMM YYYY"),
"YearMonthInt", VALUE(FORMAT([Date], "YYYYMM"))
)

 

Use the period column instead and of course sort it by the Year Month Int column.