Options on how to address this in a visual

[EricEdder]

My report uses the following tables:

WC_Capacity - Listing by date, work center and their available capacity (in hours)

WC_Load - Listing by date, work center, job and the expected number of hours to complete the job

Date - Standard Date Table including a column which converts the date to the "YYYY-WW" OR in the event that the date falls in the past, "Late".

I have the following measures:

SumOfLoad = calculate the sum of the work center Load

SumOfCap = calculate the sum of the work center Capacity

CummDiff = calculate the cumulative difference between Load and Capacity

First Available =uses the CummDiff to identify the first Year-Week in which that work center becomes available (cumulative Capacity > cumulative Load) in the event that we have too much work for it.

I currently have a clustered bar chart.  X axis is the Year-Week and Y axis displays SumOfLoad and SumOfCapacity.   I also have a seperate card visual which displays the First Available week (YYYY-WW).

It would be much more meanful to my audience if I could somehow incorporate that first available week into the existing visual to highlight that on the X axis or use a vertical line or some identifier to bring attention on the visual to that First Available Week?

If that is not easily done, perhaps there a better type of visual better suited to what I am trying to do?

Any suggestions or assistance would be appreciated.  Thank you.

[EricEdder]

Rupak,  Thank you this worked perfectly!

[v-jianpeng-msft]

Hi, @EricEdder 

I wish you all the best. Previously Rupak_bi have provided a solution to help you solve the problem. Since we haven't heard back from you yet, I'd like to confirm if you've successfully resolved this issue or if you need further help?
If yes, you are welcome to share your workaround and mark it as a solution so that other users can benefit as well. If you find a reply particularly helpful to you, you can also mark it as a solution.
If you still have any questions or need more support, please feel free to let us know. We are more than happy to continue to help you.
Thank you for your patience and look forward to hearing from you.

Best Regards

Jianpeng Li

[Rupak_bi · Accepted solution]

Hi @EricEdder ,

I think there is no straight solution. But you can get it with some twick.
1. Insted of cluster bar chart, take combo chart.

2. In the line chart, set the first available week with some dummy value.

3. format and hide the line graph and bring only the dot.

4. now set an error bar in the line chart with dotted line. 

hope this will work. If you have confusions, share some sample data.