Do you know of a combined visual to highlight Promotions?

[pdacheva]

Hi Team,

 I have a serious brain picker here. I've been looking for ways to have combined visual that shows multiple line chart with Sales (split by category like "Customer") or with multiple Measures (no split by category CY vs LY) and at the same time show higlighted (maybe with bars) when in the selected period there was a promotion. The challenge here is that the Promotions are not happening only 1 day, should not be splitted by category and I need to show the length of the promotion period (the only visual showing period length  I've fount so far are Line chart and Gantt). Promotions could be 2 types max. In some cases CY vs LY promos and in other cases 2 types split by other business caracteristic. Tried several approaches that are shown in videos and blogs out there, but nothing gives the desired visual. I managed to achieve the CY vs PY promo case with markers (adding dummy Promo measures and showing only their markers, removing lines), but this approch splits the markers by the Axis granularity and doesn't work when Sales measure is split by Category. I'm attaching some screenshots of what I currently have and my desired result in case someone has an idea how such visual or something similar could be achieved. Having two visuals one behind another is not an option either because I'm changing the Axis granularity by drilling and I need both visuals to change together.Besides, it still doesn't show the length per promotion.

Thanks in advance for any idea you might have!

[v-lili6-msft · Accepted solution]

hi, @pdacheva 

Based on my research, for your requirement, I'm afraid it couldn't achieve in Power BI for now.

If you could try to use two visuals but when changing the Axis granularity by drilling, do it two times.

Best Regards,
Lin

[pdacheva]

Hi Lin,

Thanks a lot for your prompt feedback! Yes, I asumed this is the case, but I had to do one last try :). I meant to do it in R, but the performance was really bad, therefore I was looking for alternatives.

Thanks again!

Best,