Data Not Displaying Correctly

[mlopez1987]

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 that for some reason, the visual is not showing any data for the month of January 2023. In this month, I should have one active project (dark blue), but it is not showing at all (even if I remove the filters, the data shows up but with no status). The missing data is for that month only.

Do you think is the formula I used?

Thanks for your help

I can upload the files, but don't know how.

[Ahmedx]

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

[wini_R · Accepted solution]

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:

[AmiraBedh]

Can you share your model and the DAX measures?

[mlopez1987]

Hope this link works

https://www.dropbox.com/scl/fo/3xwxrcfczgmp11tbdx0wj/h?rlkey=t73e09037ayzhhnkvo4p70857&dl=0

[AmiraBedh]

Can you point to the measures and the tables you are using ?