Forum Discussion

mlopez1987's avatar
mlopez1987
Frequent Visitor
2 years ago
Solved

Data Not Displaying Correctly

Hi!   I have a set of data (in Excel) connected to my Power BI report with several filters. I have a visual (Stacked Column Chart) to show the total area for each month; the issue I'm having is tha...
Need Help
  • wini_R's avatar
    wini_R
    2 years ago

    Hi mlopez1987 ,
    I guess the issue is caused by bad/ambiguous data model - you have several many to many both directional relationships which is not a good practice.

    When you create a relationship between Project Status and 03_Area Spread seems you get correct result:

     

Ahmedx's avatar
Ahmedx
Super User
2 years ago

this happens to you because of
1) you wrote in capital letters (ACTIVE) but it should be like this (Active).


2) due to both relationships
I need an inactive relationships here