Forum Discussion

nhodges's avatar
nhodges
Helper I
3 years ago

Date Table making affecting my visuals

Hi,   I am working with multiple dates fields and want to be able to filter them all at the same time so I made a date table. However when I make the relationships it is affecting my visuals, it is...
Need Help
BA_Pete's avatar
BA_Pete
Super User
3 years ago

Hi nhodges ,

 

You need to add a monnth column to your caledar table and use that on the axis.

In Power Query, you can use something like this:

monthKey = Date.Month([date])

monthName = Date.MonthName([date])

monthNameShort = Text.Start(Date.MonthName([date]), 3)

MonthYear =
Text.Combine(
    {
        Text.Start(Date.MonthName([date]), 3),
        Text.End(Text.From(Date.Year([date])), 2)
    },
    " "
)

 

Pete