Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
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.
Solved! Go to Solution.
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
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
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 40 | |
| 37 | |
| 35 | |
| 34 | |
| 27 |
| User | Count |
|---|---|
| 134 | |
| 101 | |
| 71 | |
| 67 | |
| 65 |