Forum Discussion
Unexpected Behavior Between Two Related Tables.
This usually happens because:
You're only using fields from the Dimension table in the visual (e.g., Name, Category), without any aggregation from the Fact table.
Power BI visuals respect filter context, and if no data from the fact table corresponds to multiple selected dimension values, the visual will appear blank.
Most often, it’s due to the visual relying on the relationship direction, which doesn’t propagate filters both ways
Solution:
Option 1: Include a Field from the Fact Table in the Visual
Option 2: Check for Bi-Directional Filter (if Required)
Option 3: Use TREATAS in a Measure (Advanced)Note:
This is not a bug but expected behavior based on how relationships and filters work.
Ensure your visuals include aggregated data from the fact table, or use DAX to handle filtering intentionally.
Avoid relying solely on dimension values without any context from the fact table.
Resolver IIHi mkpbi,
To fix the issue of visuals not showing data when multiple values are selected from the dimension table:
Check the Relationship: Ensure the relationship is one-to-many with a single filter direction (from dimension to fact).
Review Measures: Ensure your measures handle multiple dimension values properly. Use ALLSELECTED() or VALUES() in DAX to manage the filter context.
Verify Data: Check that every selected dimension value has corresponding data in the fact table.
Check Filters and Slicers: Make sure there are no conflicting filters or slicers hiding data.
Enable "Show Items with No Data": In matrix visuals, enable this option to show dimension items even if they have no data.
Use "ALL" or "REMOVEFILTERS" in DAX: Add REMOVEFILTERS() to your measures if you need to control filter context.
If the solution works for you, accept it as the solution. Let me know if you need any further help!