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:

     

wini_R's avatar
wini_R
Solution Supplier
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: