Forum Discussion
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 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.
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:
5 Replies
Can you share your model and the DAX measures?
Can you point to the measures and the tables you are using ?
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:
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
