powerbi

Hi, I have a report accessing data via sql that refreshes successfully in the desktop app with no errors shown and works great. When it is published to the workspace it errors out and gives me the below error message but if this is accurate the key not found error would have to happen in the...

Hi all, i have a date written into the SQL that links to the the data warehouse data source. Each month the user currently goes into the source SQL and changes this date manually. Does anyone know if its possible to create a user prompt on the front end dashboard so that the user can amend this...

Hi All, I was wondering if anyone know how to count the number of Sick Occasions in Dax? i know how in Excel but dax is a completely different beast. Looking at the example i have posted. I want it to show 0 if they were not absent. Then increment once they become absent. But then they return...

I have an Inventory Walk table that has month on columns and values on rows. Rows consist of Stock on Hand, Total Receipts, Total Demand, and Net Inventory. Stock On Hand is always the current month, then Total Receipts and Total Demand for each month. Net Inventory is a measure that is Stock...

Hi everyone I've got an excel sheet with data sourced from PowerBI which is utilised daily however, I'm having to click "Refresh All" under Data every time i use it. Is there anyway to automate the data refresh? The PowerBI data is updated once every morning, if I could align my data to...

Hello, I have an applicant workflow and would like to measure how long a candidate has spent in which status (per job and average across all jobs). I want to visualize it in PowerBI. I have the following table: Job Req ID Application ID Application Status Application Status Category Created...

Hi all, I am wondering if someone is able to help me out to create a visual that would look like this below (I found a topic somewhere else with same request I need today. couldn't find answers about it so I come here to check if there's luck Power BI Stacked Bar as Timeline with Milestones)...

Hi all, What is the best approach to create a waterfall like this in powerbi? I have no issues preparing it in excel but it won't load in powerbi. Glad to get advise. Data included below; Area/Goal Original Save Spend 2020 Targets 64.0 2021 Target 58.8 Train...

In PowerBI I am calculating the percentage of productivity of each of the technicians who attend tickets, to calculate the productivity of each one I am using the formula "Tickets attended * 100 / Total tickets", to calculate productivity I am creating a new measure where I am executing the...

I've attached a snapshot of my data - I'm looking to count how many shipping addresses a Partner ID has in a list of various Partner IDs. In the image the power BI formula I need is: - For Partner ID# PUS00000111 to show it has 14 'TRUE' shipping address values - For Partner ID# PUS00000342 to...

I often find myself sifting through large amounts of data to identify relevant keywords, and as many of you may know, this can be a time-consuming and sometimes frustrating process, particularly when it comes to spelling errors. To address this issue, I came up with the idea of using PowerBI to...

I have a (successful) query that Groups Rows by a business unit name, and sums a few columns to give totals those units. In a previous step I had already filtered my data to just be one month so I could check my totals against the manual report we use. Now I have opened it up to all the dates...

I have 3 markets that account for all sales for current year and last year. I am able to use the % of row calculated field to see the share of each market for each product level, but I am looking to calculate the share change for each market vs. last year for each product level. So for Dept 2 it...

I have done some basics with Power Query, but I have a need that is beyond my limited skills. So I am turning to my favorite experts here for some help. I have created multiple workbooks with analytics where users input descriptions and amounts for the different accounts. There are 6 identical...

Hi, I'm taking a shot at a real-time dashboard that I can use the PowerB REST API for. My inquiry is how the refresh of the columns works. I have 1300 records stacked once and then 2 sections per column need to be refreshed at regular intervals. The main rest call I see is adding rows, but...

Hi! New user to Power BI here and trying to learn how to convert a whole number to a HH:MM:SS format. I've done quite a bit of research but can't seem to find an exact solution online for what I need. I'm currently screening transaction ledgers and the date/time stamp is significantly important...

Hi, On the report view I have created some basic drop down lists. Whenever I choose a district and then a municipality I would like to have a summary table on the bottom of the page (please see attached) which will count how many observations I have for the specific district, municipality. I...

Hi All, Hoping can get some input from the DAX experts here. I have a table imported via power query. It has 2 columns Employee ID - this contains a list of employee IDs Month - this contains 'current month' and 'last month' value Note - The same employee ID can appear twice in the table...

HI before i start, i have also post same concept question on here but for Excel. I am looking the solution for power bi. i do have all folders and files complete path in column ( i fetch data from excel:- data source). from that i have created slicer and i need count of all subfolders and...

I am attempting to create a Power BI measure that computes the number of active employees and that can be sliced by date, based on a table that is a running list of employment changes. As a sample data set: Employee ID Change Date Status Title Change Reason A 1/1/2021 Active Director of...