Log In
Register
Home
Active Member
June 12, 2021
Offline
1.Is it possible to capture equivalent features using Visual from Power BI into Excel?
2. What are the possible features that can be used or that are equivalent into Excel for the sample output above image?
Please help. Thank you
See Answer
July 16, 2010
Offline
Hi Shyna,
Welcome to our forum!
You can create the equivalent stacked bar chart in Excel. There is no setting for a constant line, but you can add another series that replicates this feature. There also isn't a color picker, but you can easily enter a custom color using Hex or RGB codes.
As for 'responsive', it depends what you mean. You have Slicers in Excel that connect to charts which respond to selections in the Slicer.
Mynda
Active Member
June 12, 2021
Offline
Hi Mynda,
Thank you so much.
I need some clarification s what he really wanted will be the result. (He captured it in the features from Power BI) Do I need to convert it in an Excel.
From Him:
The task is to capture information from Power BI Desktop in an Excel spreadsheet. For each of the visualizations, there are a broad variety of field options, formatting options, and analytic options.
For each option that is present for a visualization type, you will enter it into an online Excel spreadsheet that I will grant you access to. I have one partially done as an example that you will be able to use as a model.
This is very simple, repetitive work since many of the visualizations share many of the same field, formatting, and analytic options.
You do NOT need to be a Power BI expert to do this, but it will really help if you have used it before. This is only for the native visuals for now.
>The data is not what matters in power bi. nor does the visual. The goal is of you to capture in the Excel I sent you all of the options and value types for each visual. you don't actually need data for this, other than a single value to activate the visual. So in the example, you sent me, you would enter individual rows for the stacked bar chart for all of the options (plus all the ones that are not shown) for things like axis, legend, values, etc.. Power BI is NOT the deliverable. the excel spreadsheet filled with all the options that are available under the data, format, and analytics tabs (show in the screenshot I attached) is what I need.
>To confirm, I don't need the screenshot. Just the values from the excel table at the top. And I don't need all visualizations on a separate tab. Just one tab with all the visualizations listed. One table with all the options from the fields, formatting, and analytics sections.
July 16, 2010
Offline
Hi Shyna,
I think you misunderstand the requirement. They're not looking to see if Excel has the same/similar functionality as Power BI Desktop, they just want you to use Excel to document the settings available in Power BI Desktop for each visual. That's what the example in your screenshot shows. i.e. they're simply asking you to do some data entry in Excel.
Mynda
Answers Post
1 Guest(s)
