Show Dates as january 1st and uptodate in the Ribbon Visual

[Anonymous]

Hi,

Instead of showing months in X axis i need to show only january 1st and updated date (July 25) in the Ribbon Visual,Can i get any tips to get that in to my visual.

Thanks,

Mishelle

[az38 · Accepted solution]

@Anonymous 

you need to create a filtered calendar table like

Calendar Table = 
FILTER(
CALENDAR(DATE(2020,1,1), TODAY()),
DAY([Date]) = 1 || [Date] = TODAY()
)

then create relationships between calendar table and your fact table and put 'Calendar Table'[Date] on the x-axis

[Anonymous]

Hi, Thanks for the reply and it works somehow 🙂 the thing is its showing as still months.I cannot make the date as date hierarchy.Any tips to show it as dates.

Thanks,

Mish

[az38]

@Anonymous 

are you sure?

it works correct for me

Have pressed "Expand all down" button in visual?