power bi

I would be so grateful if anyone can help solve a problem I am having with Power BI. I work for a mental health and disability charity. On our application form, organisations can tick who will benefit from receiving the funds that they are applying for. They can tick up to 7 boxes, with some...

So I am looking at COVID stats all day and I have to prepare them for my manager. This is a multistage process and it's fairly repetive. As a result i want to automate it so i can spend my days doing more productive **** or cat videos. Either i am not bothered. It's a multi stage process and...

Hi, Using sample JSON data I need to build a visual most like screen below. Have you seen something like this or could you advice how can i make it? Green <=9, Yellow >9 and <=10, Orange >10 and <=11, Red >11 and <=12, Black >12

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...