Graph issue

[Anonymous]

Hi all, 

I have a (blank) appearing for June data. How do I correct this issue I am having?

Regards

France

[TomMartens]

Hey @Anonymous ,

your data model consists of two fact tables, facts for 2021 and facts 2022. You have to stack both tables on top of each other using the Power Query Method Append. Use Power Query to create a column that helps to differentiate between the two files if necessary, but make sure that you have a date column that can be used to create a one-to-many relationship with a calendar table, the Calendar table being on the one-side.

Then you should create a calendar table (this is assumed to be best practice).
Here you will find an introduction to data modeling with Power BI: Design a data model in Power BI  - Learn | Microsoft Docs

Regards,

Tom

[Anonymous]

 

Hi there @TomMartens ,

I have changed the relationship to many to one, however, I am facing another issue, my data for June is not appearing on the graph. Thanks for the help, much appreciated. 

Regards

France 

[TomMartens]

Hey @Anonymous ,

(Blank) inside a Slicer or on an axis most of the time represents numeric values (the facts) coming from the many side of a relationship, the fact table that holds the numeric column, that is used directly in the values bucket of the chart or used inside  measures. But there are values present in the column that is used in the relationship on the many-side that are not available in the column used on the one-side.

If a column is used inside a slicer or as an axis (this is considered a best practice) and (Blank) appears as an axis label, the reason for this is described above.

To fix this you have to make sure that the relevant values are available in the table on the one-side, or simpy remove NULL values on the many-side.

Sometime the differences are subtle, meaning one column is of data type date and the other column is of data type datetime, and out of a sudden the June values contain a timepart that is not Midnight (12:00:00AM).

Hopefully, this provides some ideas on how to tackle your challenge.

Regards,

Tom