Forum Discussion
Matrix - Not Showing All Columns
Hello, I have a new Matrix table that I created. I've selected two columns to use in this table. Only one column displays on this table. There are arrows at the bottom of the matrix table that I can use to navigate to the add'l column. I don't want this. I rather show both columns at the same time. The unique thing about these two columns, they are ones I created within PBI. Regardless of how many fields I add to the Column visualization field, only one will display.
HI,@creynolds
You may try to use these two formula like below:
Not Started = IF( 'Production Data'[Date]>=TODAY(),1,0) Started = IF('Production Data'[Date]<TODAY(),1,0)Result:
Basic data
Best Regards,
Lin
3 Replies
Can you post a screen shot? I'm not following what is going on here.
I was able to correct the issue by creating two independent "New Measures". However my new problem -- both new measurements return the exact same result:
Started = 'Production Data'[JOB_ORIG_START] < TODAY()
Not Started = 'Production Data'[JOB_ORIG_START] > TODAY()
The result for both is returning a count of the # of occurrences. There should be no reason both columns return the exact same #.
Not Started Started
MidWest 36 36
Southeast 2 2
West 25 25
Any ideas?
HI,@creynolds
You may try to use these two formula like below:
Not Started = IF( 'Production Data'[Date]>=TODAY(),1,0) Started = IF('Production Data'[Date]<TODAY(),1,0)Result:
Basic data
Best Regards,
Lin
