Forum Discussion

ladylihms's avatar
ladylihms
Regular Visitor
7 years ago
Solved

'earliest start date'

 

My data consists of the details for classes/courses, e.g. date, location, number of enrolments etc. I want to be able to display each class/course in a stacked bar chart to visualise how many students are enrolled into each course by date and location. The problem I'm having is the same course may run on different dates and at different locations, and when I insert the course date into ToolTips, it will display the 'earliest start date', rather than the start date attached to the specific class. 

 

Each class has a unique code, and I have tried combining the course name and code into one column to no avail.

 

4 Replies

    • ladylihms's avatar
      ladylihms
      Regular Visitor

      I would like the graph to treat each course as an individual item, rather than grouping together.

      • v-jiascu-msft's avatar
        v-jiascu-msft
        Microsoft Employee

        Hi ladylihms,

         

        How about doing it like the snapshot shows?

        earliest-start-date

         

        Best Regards,
        Dale