Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Displaying correct title in matrix

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's avatar
    Anonymous
    7 years ago

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

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable

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