How to create the following visual in Power BI

[alanvicsansz]

Hello everyone, good evening. I hope you're all doing well.

I would like to ask for the community's support in creating a chart in Power BI similar to what can be done in Excel.

I’ve searched through some options in the Power BI community store, but the ones I found were missing one feature or another. I thought it would be possible to replicate something like this natively, but for some reason, Microsoft doesn't offer as many options in this area compared to Excel.

Here is the link to download the dataset:
https://docs.google.com/spreadsheets/d/1fhFLTIOjVAjJH-bh7AjBgR9zGVblw9DS/edit?usp=sharing&ouid=10687...

Could you please help me? Thank you in advance for your attention.

[raju8004212]

Hi @alanvicsansz 

for your requirement you need to load data into report and make transpose/pivot to make this 
columns will turn to rows rows turn to columns then you can utilise 
line clustered column chart to create your required chart
like 3 columns required for bars place it in column and line you required place it in line it will solve your problem

please let me know if any further help required

[alanvicsansz]

Hello @raju8004212, good evening. I hope you're doing well.

Could you please share a practical example in a file? This would make it easier to visualize the suggestion.

[KMont]

I actually have this same question as well...or similar.  I have a line excel chart where each category has a line.  I also have a total line as a separate "category".  I can not seem to replicate this in power bi despite pouring through google and AI.  I could have the totals as an area chart and then lines for the categories, but the only thing I can seem to do is a combo chart in power bi that forces my categories into columns which is not what I want.  Any help would be GREATLY appreciated! Thanks!

[lbendlin]

Repeating the same data in the same visual without clear separation is a design red flag.  Use separate visuals. 

What is the story you are trying to tell with that data?