Questions tagged [powerbi-desktop]

Power BI Desktop is the desktop application for Power BI, a free, self-service analytics tool.

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…
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…
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…
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…
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…
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:…
1 2 3
99
100