How Do Power BI Visuals Work? Values & Coordinates
Values & Coordinates. I think of values as dynamic and coordinates as static. If values are the amounts and the counts, then coordinates are the categories, attributes, and time units, which break up that value for comparison. In a Power BI data model, values typically come from transaction tables or fact tables, while coordinates typically come from lookup tables or dimensions.
Can’t determine relationships between the fields: bidirectional
“Can’t determine relationships”: bi-directional filters. Most of the time this error means that a visual has two columns from different tables with no relationship between them. But, if can also happen when using bi-directional filters. The tables are related, but Power BI can’t figure out how to manage the cross-filtering.