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
I can't seem to figure out why I can't populate a table visual with columns based on three different tables. Here is the relationship diagram and the columns that are related:
When I go and make the table visual, the Sum of Pending Charge column doesn't have any values?
I'm not sure where in the relationship I'm going wrong.
Solved! Go to Solution.
@christianunr , the reason for that can be
Dates FY do not have all the dates ( need by pending charges)
the date (pending charges) having a time stamp and not visible because of format
Create a date like
date = datevalue([Created date])
and use that in join
Why Time Intelligence Fails - Powerbi 5 Savior Steps for TI :https://youtu.be/OBf0rjpp5Hw
https://amitchandak.medium.com/power-bi-5-key-points-to-make-time-intelligence-successful-bd52912a5b...
@christianunr , the reason for that can be
Dates FY do not have all the dates ( need by pending charges)
the date (pending charges) having a time stamp and not visible because of format
Create a date like
date = datevalue([Created date])
and use that in join
Why Time Intelligence Fails - Powerbi 5 Savior Steps for TI :https://youtu.be/OBf0rjpp5Hw
https://amitchandak.medium.com/power-bi-5-key-points-to-make-time-intelligence-successful-bd52912a5b...
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 39 | |
| 38 | |
| 38 | |
| 28 | |
| 25 |
| User | Count |
|---|---|
| 124 | |
| 87 | |
| 70 | |
| 66 | |
| 65 |