Data Science Stack Exchange
Data Science Stack Exchange

Questions tagged [powerbi]

Power BI is a free, self-service analytics tool available individually or integrated with Microsoft Excel, Office 365 and all major Databases and analytics tools.

Power BI is a cloud-focused data integration and visualization service that gives you a single view of your data. Dashboards, reports and datasets are the core functional objects in Power BI.

The main components of Power BI are Power BI Desktop and the Power BI Web Service. Power BI Desktop is a design tool for integrating datasets and visualizing them in reports, then the Power BI Web Service focuses on sharing the reports and dashboards with users so that they can view and interact with them.

Power BI also has a range of APIs for programmatic access to the Power BI Web Service.

Power BI Desktop is available as a free downloaded from Microsoft.

For documentation, please see white papers.

39 questions
4
votes
1 answer

How to read html tables under multiple headers and combine them in a single pandas dataframe?

I have an html file like this:

Group 1

Col1 Col2 Col3
ValA ValB ValC

Group 2

…
Luxspes
  • 143
  • 1
  • 6
3
votes
1 answer

How can I change not only the value of the custom field but the what the field shows itself?

I need to be able to write custom fields in Power BI but the values of the fields change based off of company. For example, Twitter vs Instagram - field 1 for Twitter should show company name and field 1 for Instagram should show company revenue. So…
Noureen
  • 31
  • 1
2
votes
0 answers

How come powerbi does not SUM() properly?

I want to learn PowerBI so I downloaded it connected PowerBI to a MySQL database that uses this test data set: http://learn.evermight.net/johnlai/demostore.sql That data set has the tables invoice,invoice_item,customer,address,product. I want to use…
John
  • 121
  • 2
2
votes
0 answers

PowerBI: Yes/No if date falls within moving month-based period (REVISED)

Goal: I am trying to filter a line chart that has trends both 3 months back and 6 months out (a total of a 10 month block). Attempted Method: I tried to create a binary DAX-based yes/no filter as a column in a selected query based on the End date…
naridox
  • 21
  • 3
2
votes
1 answer

Does MS PowerBI directly connect with Azure's ML workbench?

Someone wants me to try to see if I can establish a workflow for them using PowerBI and Azure's ML, then show them how to use it. The idea is to create kind of a seemless experience for them, so they done have to worry about coding or dealing with…
Hack-R
  • 1,919
  • 1
  • 21
  • 34
1
vote
1 answer

How to only show the tooltip for a trace I am hovering over

I have a Line chart with multiple traces. When I hover over a tooltip, it shows every trace in the tooltip, not just the one I am hovering over. I have so many traces that the one I am hovering over is not even displayed in the tooltip since it's…
user176692
  • 111
  • 3
1
vote
1 answer

Which visualization tool should I use?

We consider the below function : $f(x,y,z,a) = x*y*z*a$, where $x,y \in \mathbb{Q}\cap[0,1000],$ $ a\in\{2,3\} $ and $z=z(x)$, taking values from the below table based on the level-range that $x$ belongs to. For instance, if $x=150$, then $z=5.$ I…
batman
  • 139
  • 8
1
vote
0 answers

Show overall average on plots of single data

I have data from a survey from multiple locations (1 data set per location per year, each containing about 20-25 numerical scores from 0 to 5). This data is aggregated over topics (e.g. first 5 questions are Topic 1, questions 6-10 are Topic 2) so I…
laureapresa
  • 111
  • 2
1
vote
0 answers

Calculating % by Dividing Filtered Matrix Columns in MS Power BI

Given: A monthly percentage (%) metric has to be calculated from dividing a column ('Numerator') from one table by a column ('Denominator') from another table, both filtered by month, as given in an example below: Table 1: Date_1 …
V_B
  • 11
  • 2
1
vote
0 answers

Power BI : How to concactenate a variable number of columns?

I am importing data from Jira in PowerBi directly from the web. The data contains an unknown number of columns with similar name (for example Comment1, Comment2, Comment3, etc. depending on the maximum number of comments in the issues selected). I…
Oh-No
  • 111
  • 1
1
vote
1 answer

How to accomodate different database / schema names when writing M queries in Power BI?

I am working with Power BI and I need to setup a template with some input parameters, one of them being the name of the database to get data from. To do this, I have setup a parameter (called project_database) so that users can specify the database…
Jeremy
  • 111
  • 2
1
vote
1 answer

(SOLVED) Power BI, Page level filter not working with many to one relation

EDIT: Solution found. Turns out the relations were set to Cross filter direction: Single on all relations (and the one from Month table.Month to A.Month was not set to active). Setting Cross filter direction: Both fixed the problem. I have four…
Zobtzler
  • 21
  • 1
  • 1
  • 5
1
vote
0 answers

Cannot publish a Power BI report from a Power BI optimized Client to Power BI Report Server

I recently installed a fresh-out-of-the-box Power BI server on a windows server. I had it configured and everything works just fine, I also have a web portal and a web service up and running. I also installed a Power BI Client optimized for Power BI…
עומר אנגי
  • 11
  • 1
0
votes
1 answer

Help with breaking up a column in PowerBI to make a bar chart

My data set is a list of documents. I have a column in my data set - 'Independent Variable'. This column can contain nothing, i.e. 'NA', or one variable, i.e. 'var1', or multiple, i.e. 'var1;var2;var3' and is essentially metadata for the documents.…
skytracker2917
  • 1
0
votes
1 answer

Working with two dates fields in table

I am working with dates. My fields are in order table: Start date close date order no. I have to show open orders each month. I have created a relationship with the date table by start date. I need to relations like: If the start date is in this…
RudyGem
  • 11
  • 1
1
2 3