Forum Discussion
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 following:
- USA value Bars in gray color (always shown)
- Benchmark Lines for ETF and EQST in two different lines (always shown)
- Lines for ABC and DEF (ideally, should create another slicer to control if the user would like to see all or just one of them).
Currently, the line and stacked column chart function can only show one value at a time.
Unfortunately, all my products, Benchmark Line, and recession bars are under the same table and column (e.g., ETF, EQST, ABC, DEF, etc...).
Do you have any ideas on how to make it happen?
Thanks in advance!
(combo charts in Excel)
4 Replies
- lbendlin
Super User
This looks like it can be done in Deneb. Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information or anything not related to the issue or question.
If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523Dear 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.
Thank you very much in advance.
- lbendlin
How should I interpret the USA data?
