Skip to main content

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
0 votes
0 answers
4 views

Newbie asking: consolidate multiple values (PowerBI)

I’m a newbie in data analytics and still learning. I have a small challenge and would like to ask for a smart way to solve. I’m working on RFM model, and have data look like example below: phone ...
Trung Kiên Vũ's user avatar
0 votes
1 answer
16 views

Data tables over an interactive map?

I have the longitude/latitude points of various communities within a Country. I'm interested in having a user be able to hover over a point on the map and be able to read the available data tables on ...
hollowhills's user avatar
0 votes
0 answers
58 views

Gauge issue - target value doesn't show up

I'm trying to create some visuals for a report in Power Bi, and I have this issue with a Gauge Visualization. I introduce the Total Revenues and Total Revenues (target) measures as Value and Target ...
Danasc's user avatar
  • 1
1 vote
0 answers
11 views

How to filter by two columns in a single table that both point to another table in Power BI

How do you set up a data model in Power BI when one table has several columns that point to a single other table? For example, I have a sessions table that includes columns like "providerID",...
user158471's user avatar
1 vote
1 answer
40 views

Power BI Show Multiple Datapoints on same Axis

I have a dataset that summarizes student absences grouped by School Site, Grade, Gender, Race and it is broken down into groups with total # of students that had: Absence <5%, Absence 5-10%, ...
Bijan's user avatar
  • 113
0 votes
0 answers
40 views

Is it possible to remove unneeded space from the X-axis in Power BI?

I created a line chart in Power BI, but Power BI added white spaces to the right of the x-axis. My data only goes as far to -1 in the x-axis. Is there a way to remove the unneeded space to the right ...
jeffrey's user avatar
  • 101
0 votes
0 answers
33 views

Using PowerBI calculated columns vs calculated measures to calculate a frequency flag column

Sorry for the long question. In PowerBI I have fields called 'user ID' and 'service'. Each row represents an activity, so may not be unique. I want to create a new variable called '5+ flag' that for ...
Molly's user avatar
  • 1
0 votes
0 answers
13 views

Displaying PowerBI and Microsoft Excel Files for Data Analytics Portfolio

I tried uploading a PowerBI file and an Excel file to GitHub, but it doesn't render them as GitHub would a Jupyter Notebook, for example. What service can I upload the aforementioned files to for a ...
Faith Alone's user avatar
0 votes
0 answers
114 views

I have a data set that having profit column with negative values. what should I do?

I am working on a data set that data set have a profit column with negative values what should I do can we remove it or ignore it .
akshay gaikwad's user avatar
0 votes
0 answers
108 views

Preparing geojson files for use in PowerBI

I need to prepare several GIS polygon datasets (in .tab or .shp) to geojson for use in PowerBI. I can easily convert to geojson using FME. However all my efforts have so far failed to work when our ...
Stuart's user avatar
  • 1
0 votes
0 answers
12 views

PowerBI: Pivot questionnaire data that's returned record by record into one line per respondent

This is an oversimplification of the dataset I need to work with. Actually, I have to process over 60k records spanning over 27 questions. The data is downloaded through an API and every day new ...
Jeroen's user avatar
  • 1
0 votes
1 answer
22 views

date relation between 2 tables

I have 2 tables: Budget, that include budget per month in € for each product (in each row the date is the last day of the month): 31/01/2023 product1 10000€ 31/01/2023 product2 5000€ 28/02/2023 ...
Corrado's user avatar
  • 101
0 votes
0 answers
90 views

I get incorrect numbers while dividing two columns

With this code and the attached photo why I get incorrect numebrs for priceforunit last column?!! for example the last column for the first row should be 117556.23/2829 = 41.55 priceofeachunit = ...
Ahmad Turani's user avatar
0 votes
1 answer
62 views

Why does PowerBI take longer to load data than PowerQuery takes to load preview?

I have a stored procedure in SQL Server and when I open PowerQuery, I can get a preview of the whole table in a minute or two. But once I click 'Apply and Close', it will take AGES to load and finally ...
PowerBIUser's user avatar
0 votes
1 answer
346 views

PowerBI - How to mirror a report to another workspace

Hey so I have a report in workspace A and I'm trying to mirror (reference) it to workspace B such that workspace ...
jamesruu's user avatar
0 votes
1 answer
369 views

Can not display the data becuase Power BI can not determine the relationship between two or more fields

I have added 2 separate SharePoint lists inside my Power BI desktop, as follow:- now there is not any relation between the 2 tables. and i built 2 tabs inside Power BI >> each table to show the ...
John John's user avatar
0 votes
1 answer
30 views

Using input of a 1-12 (period-based) slicer in a measure

I would like to use a slicer based on the 12-months of a year to calculate the yearly budget up until a specific month and be able to compare it to realised costs. Slicer: So, if I am in month 8 (...
Sam's user avatar
  • 1
0 votes
1 answer
688 views

Finding MIN of Multiple Columns without blanks

I have a table with 5 columns. I want to have a 6th column that gives the minimum from the first 5 line by line but some the 5 columns have blank entries so my min column picks these up as the minimum....
David's user avatar
  • 1
1 vote
0 answers
18 views

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 ...
עומר אנגי's user avatar
0 votes
0 answers
156 views

Are there any open datasets for commercial use?

I am creating a bootcamp for data analyst and it's been 2 days I am looking for some good dataset fit for commercial use that I can use to create Tableau and Power BI tutorials. Even on kaggle some ...
hyeri's user avatar
  • 141
0 votes
1 answer
2k views

Merge two data sets by date, filling in missing dates in 1st table, power bi

I'd like to merge the two data sets by the date, keeping all the dates and filling in the totals col with NULL when the date doesn't match EDIT: I’m working in Power BI Data set 1 ...
Jacob Nordstrom's user avatar
1 vote
1 answer
122 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 ...
user176692's user avatar
1 vote
1 answer
81 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$ ...
batman's user avatar
  • 149
1 vote
0 answers
27 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 ...
laureapresa's user avatar
2 votes
0 answers
58 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 ...
learningtech's user avatar
0 votes
1 answer
47 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'...
skytracker2917's user avatar
0 votes
1 answer
86 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 ...
RudyGem's user avatar
  • 11
1 vote
0 answers
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 ...
V_B's user avatar
  • 11
1 vote
0 answers
25 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 ...
Oh-No's user avatar
  • 111
1 vote
1 answer
201 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 ...
Jeremy's user avatar
  • 111
2 votes
0 answers
206 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 ...
naridox's user avatar
  • 21
1 vote
1 answer
18k 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 ...
Zobtzler's user avatar
0 votes
1 answer
7k 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 ...
powerbioverflow's user avatar
0 votes
1 answer
74 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 ...
Pardhu's user avatar
  • 21
3 votes
1 answer
78 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 ...
Noureen's user avatar
  • 31
0 votes
1 answer
4k 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 ...
knightro's user avatar
4 votes
1 answer
5k views

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

I have an html file like this: ...
Luxspes's user avatar
  • 143
0 votes
1 answer
191 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 ...
Vamsi Krishna's user avatar
0 votes
1 answer
134 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 ...
surpavan's user avatar
  • 145
2 votes
1 answer
122 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 ...
Hack-R's user avatar
  • 1,919