I am new to Power BI and new to the forum, I have been following the Ultimate Beginners courses through to creation of Measures hence I am confident ( ) that I am lacking understanding …
- I create a Date table (as per Sam McKay’s script), and then create a slicer on Year - the slicer shows all the years in the date table
- I import voyage data and link the Date table date to the Voyage/Commence Date Gmt field, 1:many
- Immediately the Year slicer has added a ‘Blank’ value as well as the actual years
Now I have checked that every row of the Voyage data has a valid Commence Date field.
I did this with a small manually entered test data set and all was ok, but I cannot see the difference. The effect of the blank value is then that a Matrix visual also goes wrong.
Any ideas most welcome…
PS How to include screenshots ?