Power BI Desktop is the desktop application for Power BI, a free, self-service analytics tool.
Questions tagged [powerbi-desktop]
3559 questions
0
votes
0 answers
PowerBI service hover over visual does not show header to allow me to export data
When in powerbi desktop, I can hover over this visual and the header shows up to allow me to export data. When I publish to the service, this no longer happens.
In Options > Report Settings > Export Data I have the option checked to allow end users…
oilers128
- 172
- 1
- 3
- 12
0
votes
1 answer
Label scatter points in PowerBI
I have 3 columns, "Price" (decimal), "Returns" (decimal), and "Ticker" (text). I would like to create a scatter plot in PowerBI. In the scatter plot, I would like each point to be labelled with text from the Ticker column, within the plot area.
All…
Clemence Padya
- 63
- 6
0
votes
0 answers
Power BI ( PowerQuery) - Checking if values from three columns exist in three other columns
I'm pretty new to PowerQuery I'm facing a little issue. I have two tables in powerquery with the following structures ( samples ):
Table 1 ( model…
LBSST
- 1
- 1
0
votes
0 answers
Power Bi Measure to calculate average of 3 values in a row (no moving/rolling average)
I have a table that looks like this.
Index
MATNR
VALUE
expected column
1
A
30
3
A
32
4
B
33
31,67
6
A
35
7
B
30
10
B
32
32,3
I need the average of each 3 rows, sorted by (non continious) rank, due to filtering.
The…
Hugo
- 11
- 2
0
votes
1 answer
How to do a simple calculation in an DAX AVERAGE function?
My goal was a simple calculation inside my AVERAGE Statement in PowerBi. The value Einheitsvalue can range from 1 to 5 and I wanted to subtract it from 6 ( 6 - Einheitsvalue ) to get a inverse value.
In my PowerBi Statement it looked something like…
Fred
- 17
- 5
0
votes
0 answers
Applied filters in dax is not working when we supplies multiple values
here for each quoteId I have multiple quotes panels.
if I match mandatory panels to quote panels - (using Power query - left join) - if the mandatory panels don't match, i will get nulls for a few panels
here the problem is - when I supply multiple…
usmansharif shaik
- 65
- 8
0
votes
1 answer
Creating Relationship in PowerBI when Employees are in columns by role
I'm trying to create a relationship in PowerBI between an Account Assignments table, which lists each Account in a role, and then the assigned employee in the columns. One column is used for each role.
So for example:
Account Sales Rep …
WesBez
- 1
0
votes
1 answer
PowerBi connect to postgresql with Pythonscript
I have a Pythonscript that runs fine in Juypter. If I paste the same script in PowerBi > Transform data > Advanced Editor I get errors that refer to the string literal quotes.
Postgresql expects double quotes and PowerBi wants it to be single…
Tralala
- 233
- 2
- 10
0
votes
0 answers
Cumulate sum in PowerBI
I'm trying to make a cumulative sum using a Quick Mesure in Power Bi but the result is not what I'm looking for.
The function PBI proposes looks like this :
Mesure 2…
Alan Nuñez
- 1
- 2
0
votes
1 answer
Date Difference on having condition on Dates (Power BI DAX)
I am trying to display number of days between two dates:
I have two date columns (Joining_Date, Resigned_Date) in EMPtable and have created Independent Dimdate table and created slicer for Dimdate .
Now i want to get datediff between [Joining_Date]…
swad
- 87
- 2
- 9
0
votes
1 answer
How do I make a stacked bar graph in Vega-Lite where the bars are count but the data labels are percent?
I am trying to make a stacked bar chart in vega-lite so that I can use it with Deneb in PowerBI. In this simple example), the expected behaviour is that the X-axis should be variety, and the Y-axis should be count of site coloured by site. The text…
James Mathews
- 3
- 2
0
votes
1 answer
How to add a grand total row with averages in PowerBI
Hi I am new to powerbi and I am trying to figure out how to add a grand total row showing averages rather than the sum. The below table is what I have in powerbi desktop now minus the grand total row at the bottom. I am looking to have the averages…
tia97
- 350
- 4
- 8
- 16
0
votes
0 answers
Power BI - Calculated column for occurrences over 50%
Anyone help?
Just two directly related tables, Purchase Header & Purchase Line with direct relationship between the two based on two common columns (Delivery No).
I want to calculate the number of lines where the delivery is greater than 50%. So the…
Tob_P
- 1
- 1
0
votes
1 answer
Is there a way to show custom text based on column value in Power BI Desktop?
lets say I have a table like this:
Name
Value
Month
Year
John
20.2
1
2022
John
221.2
7
2022
John
320.2
1
2023
Miles
301.1
1
2022
Miles
301.2
7
2022
Miles
33.5
1
2023
I'm showing the data in a matrix visual and filtering…
AzUser1
- 183
- 1
- 14
0
votes
0 answers
Find max amount between date range by grouping columns and sum that max amount by grouping columns
Good day friends.
I have dataset below in Power Bi Desktop.
I need determine max amount between a date range by grouping ID, Group, User. After that sum max amount (between same date range) by grouping Group and User.
1:…
garib hasanov
- 1
- 3