Remove duplicate date on x axis bar chart

[Prabhu]

Hi All,

My bar chart dimension is displaying repeated MonthYear values. I want it to be displayed only unique MonthYear values.

Below is my chart dimension

=DATE(DATE#(Open_Time,'DD-MMM-YYYY'),'MMM-YY')

I tried this as dimension, but no use: Date(Floor(DATE#(Open_Time,'DD-MMM-YYYY')),'MMM-YYYY')

Please help

@sunny_talwar 

[dplr-rn]

use monthstart function
change your dimension to
DATE(monthstart(DATE#(Open_Time,'DD-MMM-YYYY')),,'MMM-YY')