Data visualization

[abhishek_ap4]

Hi All, 

I'm calculating set of dates based on user selected Instore date (below is the screen shot) in DAX,

Based on Instore date say (Jan, 1 , 2022)

I'm calculating other dates (FG Arrival to DC, Request PR Release Date, etc...) 

I trying to plot these date in a visulization which would give user a time line distribution from Instore date to PR release date), can you please suggest a vizulization i can use? the problem i'm facing is I'm not able to use above calculated measures to plot in graph, 

I'm trying to active sometihing like below image, 

Please suggest, any visual which I can use to display something similar to above using the calculated dates above, 

Any help would be greatly appriciated.

[abhishek_ap4]

Thank you @MFelix  for the solution, the onlt problem i see is the Calculated Date Measures can not be used as Satart Date and End Date for Gantt Chart right ? 

[MFelix]

Hi @abhishek_ap4 ,

To what I understand from your post the dates are calculated with a DAX measure correct? In this case I would add something similar to this:

Measure = IF([Measure] = MAX(Calendar[Date]), 1)

This will check if the measure value (date) is equal to the date table value so you can use it on a gantt chart that will place that 1 on th exact date you need.

If this does not work can you please share a mockup data or sample of your PBIX file. You can use a onedrive, google drive, we transfer or similar link to upload your files.

If the information is sensitive please share it trough private message.