power bi

Hello everyone. New to the community but excited to be part of this group to grow my skills and help others along the way. I am hoping to get some help on ranking production levels for bonus purposes. I have a table with the names, and measures for the units accomplished by them. I also have...

Hi experts, I am relatively new to power query and I have a very complicated scenario (at least I believe so). With my limited knowledge on power query I couldn't achieve my desired output. I humbly request you to provide me solution or a workaround to achieve my expected results. I have...

I would like to create a Power BI Report to help with forecasting. Part of what I would like to see is the following based on an input of a specific date any user could enter. Not sure if that's possible in Power BI: - Previous Year (Day) - Not the Date but the Day of the Week for the previous...

Hi Folks, I am stumped. I am trying to merge two tables into a new table using a LEFT JOIN. Both tables have unique records on each row. When I join the tables, BI creates duplicate rows on some records for no apparent reason. The duplicates are identical in every way. I followed the steps...

I have a Matrix visual with the following: Dates (MM DD YYYY) on Columns ApplicationKey on Rows Application Status on Values The Dates (datetime value) column represents the date/datetime the application progressed from one status to another; this could be the same date but minutes or...

Hi , I want to write code in powerBI to replicate the data in column "Ratio" attached in excel. Divide column [Amount] with data present in the Earliest date in the dataset(02/01/2019- for Kum; 01/01/2019-for Ud)

Hi, I have created a custom tooltip in PowerBi to show additional data on stacked column chart, however when hovering over the chart (regardless top or bottom bar), it only shows data for the bottom bar. Does anyone know, how do I show data for both bars separately?

The automated totals in the report visual table are incorrect. How do I fix this? Additionally, is there a way that I could substitute the automated totals row with my own measure? Picture of Table

Hi and thanks in advance for any guidance on this. How can one export a dynamic (I can get static pivot tables) pivot table to Power BI from Excel? I exported two columns of data, summarized them with Excel to see what I was looking at, using groupings that are difficult to emulate in Power...

I'm trying to find out how to get the average output value that is specific to a unit, tractor, department, and model, into a measure, and then multiply it by a hard-coded number. The relationship between these factors is seen in the Data Table photo. The average output value changes based off...

HI I'm using the SWITCH/TRUE function to create a Yes /No return on a column that is generating the number of months between to date. The issue is where between some on the date the number of months is 0 (zero) and some are blank. I can see from filtering the column there are 393 zero's that...

Hello, Thank you for looking into my question. I have series of x_value and y_value. I am looking for excel equivalent SLOPE function in PowerBI. Can you please help me with measure to calculate SLOPE for below data points? Expected Output SLOPE (m) = 1.34556304295796 y_value x_value...

Hello There, I have couple of concerns if you could help me understand? 1. I am trying to understand the pricing Vs features available; the feature ‘Paginated (RDL) reports’ is not available under Poewr BI Pro. I am not quite sure what this feature mean? Is it about the ability to create...

Hi Everyone, In example below we see John Doe recently changed managers. We know John changed managers on March 1st of this year. Normally the easiest way to input this change would be to simply go into our excel file that is being used as the source for the dataflow and change the manager’s...

Dear all, I am completely, absolutely 100% new at Power BI. This is my first official day, so please bear with me :) I currently have the following Dashboard: Now, if I insert an image I can get it it to fill all of the screen except for below the dotted line (my red arrow is pointing at...

I have run into an issue when attempting to update and add new queries in BI. When adding a SQL query with no additional steps, the preview runs, but when I go to apply it, it doesn't do the query type selection and then doesn't apply the changes. It still notifies me that here are changes to...

Good Afternoon I need help to work out how to show the proportion of days taken per category. I have posted how this looks in Excel however I am struggling to create a Measure in Power BI to replicate it. My data is in one large table, called Sheet 1! The example below: first 2 columns are...

I am trying to create a bar chart with below clusters. Blue = 2020 Orange 2021 The data comes from Excel: Year 0-100.000 100.000-500.000 500.000-1.000.000 >1.000.000 2020 37,13% 40,0% 33,33% 33,33 2021 47,45% 36,41% 29,27% 20,59 So far I have done this: Step 1: Query Editor Step...

I am looking for a way to count how many values on Visits[Regarding Account] ARE NOT on Accounts[Account Name]. In below example the result should be 2 (C and E). The data is two columns in two different tables. Visits[Regarding Account] Accounts[Account Name] A A A B A C B D...