Issue in creating Visualization

[Anony_mous]

Hi All,

I need to create a visualization which shows how many employees trainings have already expired, completed , expiring in the next 6 months   in one visualization.I have the date column for training completed and there is no date column for already expired and expiring in 6 months. And which visualiztion is suitable to show all the data in 1 visualization. How to handle by writing any measures or is there any way to handle this(I think to handle we need additional date column for the dates appearing in the coming month and year or my assumption is wrong) Please help me to get through this.All suggestions are welcome Thank you in advance.

Regards,

Anony_mous

[TomMartens]

Hey @Anony_mous ,

without knowing how your data looks like it's difficult to provide any help.

Create a pbix that contains sample data, but still reflects your data model (tables, relationships, calculated columns, and measures). Upload the pbix to onedrive, google drive, or dropbox and share the link. If you are using Excel to create the sample data, share the xlsx as well.

Next to that, I recommend creating a linechart, with three measures. The x-axis is visualizing the time, and each measure represents a number of

• completed trainings
• expired trainings
• trainings to expire (projection)

Regards,

Tom