the numbers of date to dd.mm.yyyy , and get only last week dates

[zgrshn]

Hello Dear All

I have a table like this (the "Date" Column type is "Date/Time"),

and ı get the dash like this 

I deleted the year,quarter and Month from the "date" Axis, and I get

and as you see there are only the numbers of date .

But I want to do it with only short time (dd.mm.yyyy)

I can create a new column ,change the type of date to TEXT and use the left formula , but I think it is not true way .because after it, I must create a filter and get ONLY last week data (There is data in the last 2 years on my table.)

 .pbix file here

[v-sihou-msft]

@zgrshn

in Power BI, when you put a date field into a visual, it will generate a date hierarchy automatically. To have date appear on visual only, you just need to select "Date" instead of "Date Hierarchy" as @Anonymous suggested.

To filter the last two week data, you can apply visual level filter like below:

Regards,

[Anonymous · Accepted solution]

That automatic hierarchy under Date with Year, Quarter, Month etc. lets you use the drilldown feature - see https://powerbi.microsoft.com/en-us/guided-learning/powerbi-learning-2-6a-explore-time-based-data/  

You should be able to get just the (short) date if you want by clicking the drop-down beside that Date field under Visualisations, and tick 'Date' instead of 'Date Hierarchy'.  This should give you an entry for each date on the X axis, but you'll lose the drill-down feature linked above.