New Enterprise DNA Initiatives

Mixed area/line chart

Data Visualizations
#1

Hi,

The business scenario is that contracts guarantee a minimum and maximum volume per month. New contracts start, old ones are renewed or are lost. The attached is dummy data generated in Excel with the grey area showing the overall min and max volume per month, the yellow line is the central/average and blue the actual volume showing the undershoot of volume in June & July.

Area-line
Area-line782×461 25.8 KB

In Power bi I have been able to do this with an area chart overlaid with a line chart but aligning, scaling and duplicated axes makes this solution very fragile. Does anyone have better alternatives ?

With thanks
Nick

#2

@Nickj Can you please share your sample PBIX file to work with?

Thanks.

#3

COA Performance.pbix (827.7 KB)

Hello MudassirAli, many thanks for wanting to take a look. In the pbix attached, you will see a version looking similar to my Excel mockup. The pbix version is an area chart and a line chart one on top of the other. At present the legends and axes names are overlapping. Removing these results in the scaling of one chart changing. So my question comes down to whether any one knows of another visualisation that provides lines over areas natively. FYI I started looking at Charticulator and while that can produce much more sophisticated results, there looks to be a significant learning curve. thanks again, Nick

#4

Hi @Nickj, we aim to consistently improve the topics being posted on the forum to help you in getting a strong solution faster. While waiting for a response, here are some tips so you can get the most out of the forum and other Enterprise DNA resources.

  • Use the forum search to discover if your query has been asked before by another member.
  • When posting a topic with formula make sure that it is correctly formatted to preformatted text </>.
    image
  • Use the proper category that best describes your topic
  • Provide as much context to a question as possible.
  • Include the masked demo pbix file, images of the entire scenario you are dealing with, screenshot of the data model, details of how you want to visualize a result, and any other supporting links and details.

I also suggest that you check the forum guideline How To Use The Enterprise DNA Support Forum. Not adhering to it may sometimes cause delay in getting an answer.

Please also check the How To Mask Sensitive Data thread for some tips on how to mask your pbix file.

#5

Persevering with just using lines, I get this. Not perfect but good enough and much better than overlaid area and line charts :slight_smile:

2020-12-17_13-58-04
2020-12-17_13-58-041644×676 107 KB

#6

I do agree with Nickj solution on line chart but if you want to use overlaid charts switch off the X and Y lables title, as well charts titles and add only one with the content you want to show

can get something like this

007
007935×429 27.2 KB

1 Like
#7

Hi @Nickj, did the response provided by @LucaB72 help you solve your query? If not, how far did you get and what kind of help you need further? If yes, kindly mark the thread as solved. Thanks!

#8

Hi @NickJ, we’ve noticed that no response has been received from you since the 18th of December. We just want to check if you still need further help with this post? In case there won’t be any activity on it in the next few days, we’ll be tagging this post as Solved. If you have a follow question or concern related to this topic, please remove the Solution tag first by clicking the three dots beside Reply and then untick the checkbox. Thanks!

#9

Hi LucaB72, Thank you for thinking on this. We are in the same place, to get the desired result, overlay the charts. But that leaves me concerned with ongoing support worries so I will stay with a simpler line-only version for now :-(. That area/line charts are not available is quite a surprise, even a little goggling brings up examples of this format being used.

Thanks again,
Regards
Nick