Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have a matrix to show the average time of when a bus arrives at a stop. I've used this measure before and had no issue:
After adding the measure:
Note that the fields following route are not correct for #6, so I'm extremely confused as to why adding this measure breaks everything, especially since the unformatted variant works just fine.
Everyone one of those fields comes from the same source table.
Any idea what my issue might be?
EDIT:
Digging deeper I realized that the correct values are deep within the matrix when the fields are actually valid for the route in question... so fundamentally the question is how to I prevent this invalid rows from appearing.
Hi @Braunnz ,
What's the data type of [Act. time] ? Number type ——Seconds or Time type——Time?
Please provide me with more details about your table and your problem to clarify your scenario. Or share me with your pbix file after removing sensitive data.
Refer to:
How to provide sample data in the Power BI Forum - Microsoft Power BI Community
How to Get Your Question Answered Quickly - Microsoft Power BI Community
Best Regards,
Eyelyn Qin
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
99 | |
80 | |
70 | |
59 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |