Displaying correct title in matrix

[Anonymous]

So I'm trying to make a matrix that shows various iterations of a project. The iterations are entitled as 1 , 1.2 , 1.3.4, etc. Each iteration has a name whether it be 1 or 1.3.4.5 . Each number there is stored in a seperate column, for example, 1.2 is stored as 1 in column ON1 and 2 in column ON2 then blank for the rest of the colmns. How I currently have my matrix set up, it displays the first number before the period then you cick a drop down to get to the next and so on. My only issue is that it does not display the correct name at first glance. For example the name of 1 is Project Finance, but unless you hit the +, it only displays the word requirements. Then once you make it bigger, it gives you the correct value. I've tried googling this problem and couldn't find anything, so I thought I would hit up the community boards!

[Anonymous · Accepted solution]

so I solved this myself lol

I realized I just had to make a measure that displayed the following:

NameNS =

if(

ISFILTERED(Task_Table1[ON5])&& (VALUES(Task_Table1[ON5])<>blank()),

VALUES(Task_Table1[Name]),

if(

ISFILTERED(Task_Table1[ON4])&& (VALUES(Task_Table1[ON4])<>blank()),

CALCULATE(VALUES(Task_Table1[Name]),Task_Table1[ON5]=blank()),

if(

ISFILTERED(Task_Table1[ON3])&& (VALUES(Task_Table1[ON3])<>blank()),

CALCULATE(VALUES(Task_Table1[Name]),Task_Table1[ON4]=blank()),

if(

ISFILTERED(Task_Table1[ON2])&& (VALUES(Task_Table1[ON2])<>blank()),

CALCULATE(VALUES(Task_Table1[Name]),Task_Table1[ON3]=blank()),

if(

ISFILTERED(Task_Table1[ON1])&& (VALUES(Task_Table1[ON1])<>blank()),

CALCULATE(VALUES(Task_Table1[Name]),Task_Table1[ON2]=blank()),blank()

)))))