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.
24
questions with no upvoted or accepted answers
3
votes
1
answer
74
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 ...
- 31
2
votes
0
answers
191
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 ...
- 21
1
vote
0
answers
14
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 ...
- 11
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 ...
- 111
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 ...
- 11
0
votes
0
answers
13
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 ...
- 101
0
votes
0
answers
18
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 ...
- 1
0
votes
0
answers
8
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 ...
- 101
0
votes
0
answers
36
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 .
0
votes
0
answers
38
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 ...
- 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 ...
- 1
0
votes
1
answer
19
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 ...
- 101
0
votes
0
answers
16
views
Having trouble manipulating data to make better dashboard
I have a test dataset which has has 39 columns. Index is given below:
Sample data is as follows:
Some columns are omitted due to privacy concerns. The colored cells in the index belong to one type. ...
0
votes
0
answers
71
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 = ...
- 239
0
votes
0
answers
22
views
PowerQuery/BI: How to group sub-populations of variable size and perform calculations
I have data for planned and actual produced quantities for a number of items (articles) and batches. Please see example data in image and attached table. I wish to calculate:
Note: For a specific item ...
- 1
0
votes
1
answer
41
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 ...
0
votes
1
answer
174
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 ...
- 1
0
votes
1
answer
223
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 ...
0
votes
1
answer
25
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 (...
- 1
0
votes
1
answer
516
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....
- 1
0
votes
0
answers
138
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 ...
- 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
...
0
votes
1
answer
80
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 ...
- 11
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 ...
- 21