Forum Discussion

Lesveilleurs's avatar
Lesveilleurs
Frequent Visitor
2 years ago

Combo chart - Benchmark Line and value Bars to Power BI Visuals

Hi, I'd like to copy the Excel combo chart into Power BI with a Benchmark Line and value Bars, as follows: However, I'm not able to find a way to include all products.   I want to show the followi...
Need Help
Lesveilleurs's avatar
Lesveilleurs
Frequent Visitor
2 years ago

Dear lbendlin,

 

Thank you for your previous suggestion. I must apologize as 'Deneb' is too advanced for me.

I tried googling it but still don't know how to use it. Therefore, I am still seeking your guidance and help."

 

I've created a sample dataset in PBIX, and I hope the information is clear.

I've also attached 2 Excel files:

(1) Raw data used for the sample

(2) Reference chart for how the final chart should look like.

 

Sample Data 

 

Thank you very much in advance.

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
2 years ago

How should I interpret the USA data?

 

 

  • Lesveilleurs's avatar
    Lesveilleurs
    Frequent Visitor
    2 years ago

    We add the USA number as a secondary column in Excel to represent the period. Therefore, we enter "1" only to highlight the Y-axis from the minimum to the maximum number.

     

    The actual numbers can be found through USA gdp-growth-rate 

     

    In power bi, [USA] number should be the grey colum bar in line chart

     

    • Thanks!