Display some measures as row and some as columns in Matrix or Inforiver visual.

[lucky_jyoti]

Hi All, 

I am trying to have a visual created in Inforiver/Matrix format in which my measures will be displayed as row-wise, however the YTD values for these logics should be displayed as headed in the column-wise (title). Refer to the last 2 columns in the image. 

Has anyone done this before for any requirement? Need quick suggestions. 

[v-jianboli-msft · Accepted solution]

Hi @lucky_jyoti ,

Based on your description, I have created a simple sample:

Please try:

First create a new table like this:

(Create a table that has the visual column names you need and their dates)

Table 2 = 
var _a = SELECTCOLUMNS('Table',"YeraMonth",'Table'[YearMonth],"Date",'Table'[Date],"Sort",[Sort])
var _b = ADDCOLUMNS(FILTER(CROSSJOIN({"2022YTD","2023YTD"},SELECTCOLUMNS('Table',"Date",'Table'[Date])),YEAR([Date])=VALUE(LEFT([Value],4))),"Sort",SWITCH([Value],"2022YTD",MAX('Table'[Sort])+1,"2023YTD",MAX('Table'[Sort])+2))
return UNION(_a,_b)

Manage relationship:

Sort by column:

Then replace the visual's original Columns field 'Table'[YearMonth" with 'Table2'[YearMonth":

Final output:

Best Regards,

Jianbo Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.