Date slicer VS Line and clustered column chart

[Anonymous]

Hi all

I was looking to create a "Line and clustered column chart" and show last 14 days with date slicer. In a nutshell, I am looking to show same data on the chart like in the table. However, the chart does not recognize last 14 days from today and displays number od the day within a month instead. How can I replace x-axis days within a calendar month with last 14 days? 

. 

[amitchandak]

@Anonymous , It seems like you use a date hierarchy and drilled down. Use The expand icon , the reverse square Y, and contact label option and try this. These are days of August and Sep, without month.

[Anonymous]

@amitchandak - would you mind pasting an image where to click it? I do not understand the instructions you gave but you seem to understand the problem (yes, I use date hierarchy)

[v-xuding-msft · Accepted solution]

Hi @Anonymous ,

Please try like this: