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!Vote for your favorite vizzies from the Power BI Dataviz World Championship submissions. Vote now!
Trying desperately to understand why I am getting to different dates from the very same column in a table, through 2 different visuals.
Visual One > Adding a Text Box with "Value" that is "Latest Calendar Date"
... this one sometimes works the first time, but rarely moving forward
Visual Two > Adding a Card using "Latest Calendar Date
... this one is consistent
It would be nice to be able to rely on the Text "Value"
As mentioned, I am using the very same column from the very same table for each of these.
Any thoughts?
Solved! Go to Solution.
Hello, @jusTodd ,
depends on how you use it, but perhaps sometimes it's sorted based on the text value, sometimes on date value, which will differ mostly likely.
I recommend just creating measure from your column, like MAX('table'[Column]), then you will get consistent values.
Hello, @jusTodd ,
depends on how you use it, but perhaps sometimes it's sorted based on the text value, sometimes on date value, which will differ mostly likely.
I recommend just creating measure from your column, like MAX('table'[Column]), then you will get consistent values.
Thanks @vojtechsima ! That is a great piece of advice and exactly what I shall do.
Vote for your favorite vizzies from the Power BI World Championship submissions!
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
Check out the January 2026 Power BI update to learn about new features.
| User | Count |
|---|---|
| 65 | |
| 50 | |
| 42 | |
| 23 | |
| 21 |
| User | Count |
|---|---|
| 139 | |
| 116 | |
| 53 | |
| 37 | |
| 31 |