Hourly traffic by sales amount

[Anonymous]

Hi,

I couldn't find any similar solution.. I need help with my calculation to see hourly traffic by sales amount in a chart..

[v-chuncz-msft · Accepted solution]

@Anonymous 

You may drag the calculated column below, change date type and format under Modeling tab. Besides, in the Format section of the Visualizations pane, expand the X axis card and change the Type option from Continuous to Categorical.

Column =
TIME ( HOUR ( 'Table'[Date] ), 0, 0 )

[Cristhian_BI]

Hi,
Im also trying to visualize my sales by the hour, however when i create the column, the dates it shows me is the year 1899 and in a hierarchical field.
My question is, where should i create the Column, in my DateKey Table, or on my sales Table? either way it fails.
I have attached a file of the outcome.
thanks in advanced

[Anonymous]

someone got any idea? how to create such a report below?