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.

Filter by
Sorted by
Tagged with
4
votes
1answer
4k views

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

I have an html file like this: ...
3
votes
1answer
34 views

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 ...
2
votes
1answer
117 views

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 ...
2
votes
0answers
42 views

How come powerbi does not SUM() properly? [closed]

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 ...
2
votes
0answers
112 views

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 ...
1
vote
1answer
51 views

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$ ...
1
vote
1answer
7k views

(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 ...
1
vote
1answer
18 views

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 ...
1
vote
0answers
51 views

How to display quarterly data in Power BI

I have a Power BI report with a Date (slicer) visual like that. In a Data Model there is a tabel 'Date' that corresponds to this visual. At the moment there are only Day, Week, Month and Year ...
1
vote
0answers
25 views

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 ...
1
vote
0answers
1k views

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 ...
1
vote
0answers
21 views

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

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 ...
1
vote
1answer
49 views

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 ...
0
votes
1answer
16 views

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'...
0
votes
1answer
2k views

Why is my Count (distinct) not working the way I would expect it to be? PowerBI

My total is set as Count (distinct). However, the total itself doesn't make any sense, as you can see in my attachment. Any ideas what I'm doing wrong? By not making any sense, I mean that the numbers ...
0
votes
1answer
182 views

Interactive Data Visualisations

So I have finally gotten a hold of ggplot2 and ggvis packages and tried out shiny too to have interactive graphics and visualizations. but i have been using Power BI before and came to R as a an good ...
0
votes
0answers
19 views

PowerBI - apply single field filter to multiple datasets?

Full disclosure, I am a powerBI n00b. I am working on a report for data generated by an external system. This system exports data into different tabs in an excel sheet(lame, I know). I am needing to ...
0
votes
0answers
13 views

How to use query parameters in PowerBI?

I'm fairly new using PowerBI. I need to create a report using a query like this: ...
0
votes
0answers
18 views

Power Bi breaks when I add Sort By Column on a field

Here's the issue: prior to choosing Sort by: After Choosing Sort By: Here's the table, and this is also the sort by column I am choosing: The formulas that are changing to 100% are a few measures ...
0
votes
0answers
26 views

How can I map line spatial data in Power BI without ArcGIS?

I'm looking for a way to map line shapefiles in PowerBI. The native maps only handle polygons or points and have limited functionality. The ArcGIS for PowerBI tool requires a subscription that is far ...
0
votes
0answers
33 views

Power BI - JSON file formatting doesn't work

I have created the following test report by Power BI Desktop with one Card visual. I saved this formatting into the JSON file (View => Themes => Save current theme) because I want that the same ...
0
votes
1answer
43 views

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 ...
0
votes
1answer
49 views

comparing data from first quarter in two years

How can I compare data from two quarters? What software can I use to do it parallelly side by side so I can compare them. What kind of factors can I take into consideration, I'm posting a sample data ...
0
votes
1answer
2k views

Create a measure that converts minutes into hours [closed]

My searching is weak so I didn't find anything that satisfied my need. I have a dataset of work items. I have a lead time column present on each record. It is in minutes, and I want to create a ...
0
votes
1answer
78 views

DistinctCount for relatedtable with additional filter

In powerBi, a column is created with below formula, and it is working good. activedays = COUNTAX(RELATEDTABLE(ActivesInactiveData),ActivesInactiveData[Surface Date]) However, I want to add a filter ...