Stacked Bar chart with dates

[LP27]

Hi Everyone,

I have got the below table-

ID	PR1	PR2	PR3	PR4	PR5	PR6	PR7
A001	01/10/2019	01/20/2019	01/25/2019	01/27/2019	01/29/2019	02/02/2019	02/04/2019
B002	01/15/2019	01/19/2019	01/25/2019	01/27/2019	02/03/2019	02/07/2019	02/07/2019
C003	01/16/2019	01/17/2019	01/26/2019	01/30/2018	02/02/2019	02/18/2019	02/20/2019

Now i need to create a horizontal Stacked Bar chart. I have created the Stacked Bar Chart. 

But the issue is I am not getting the right format of dates in Stacked Bar chart, not sure what is the issue.

Please find the image attached to have a look at my Stacked Bar chart.

Please let me know if you have questions.

Thanks in advance! 

[Kushal_Chawda]

would you be able to share sample app?

[LP27]

App is actually big, but the table which i shared in post is exactly the
same and the format of date is in same format only.

[patilamay]

What's the expression you're using in you bar chart?

Thanks,

[Kushal_Chawda]

are you applying Date() function over these fields?

[manoranjan_d]

try to use date () in the chart or script for the fields

[LP27]

Actually, I know this should  be wrong.

For Dim - I add ID 

For Measures- I add sum(PR1) has 1 measure and sum(PR2) has 2nd measure ans so on... 

[LP27]

I tried date() it dint do magic.

[LP27]

I tried and it was still the same.

[manoranjan_d]

please let us know your actual requirement, what things need to be done on the chart.