Forum Discussion
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!
- Anonymous7 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
- AnonymousNot 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())))))