power bi desktop

Looking for some help with a DAX formula to calculate the WoW percent change. I have the formula below but the card visual doesn't have any value displayed and I cannot figure out my error. Any help is much appreciated. % Change Sales = VAR CurrentValue = SUM('Sales'[Units]) VAR...

I have three tables, Public Holidays which contain (Date, Holiday Binary (1 for each date that is a holiday date)), CalDates that contains (Date, WorkingDay_Mark (1 for working day, 0 for non working day)) and Deployment_Mailbox that contains (Date Received (Date the email was received)) I need...

Can someone figure out what is wrong with my code? Purpose of the code: If the column Brand is filtered and SKU is not --> value sales of 2022 of the whole brand with all SKUs If the column SKU is filtered --> value sales of 2022 of a specific SKU If no filters --> value sales of 2022 of all...

Hi, If new records are being added every second to the source table which is connected in a Direct Query mode, how can I have them included in the Agg table? It seems to me that the Agg table will only calculate the records that were imported in the last refresh. Hence, the usage in the Agg...

Hi, I have 15 Excel reports sourced from SharePoint. The Source.Name column captures the report name which has the date mentioned. Please advise how I can create a Report Date column that only captures the date from the Source.Name column so that I can hide the Source Name column before loading...

I have Power BI online thru our city. I have a data set that I was working with using Power BI Desktop. When I am using the online app, I tried to refresh the data. I am getting this error: Data source error: Scheduled refresh is disabled because at least one data source is missing...

I wan to show Total call, call resolved and unresolved in the same coloumn chart. how can we attain that. please see the image for reference. Thanks in advance I am referring to Power BI clustered coloum chart

I'm trying to create a visualisation that goes back 12 months from the selected date in a slicer. Using this video - I have this code: TRI P12M = VAR ReferenceDate = MAX ( 'Date'[Date] ) VAR PreviousDates = DATESINPERIOD ( 'Previous Date'[Date], ReferenceDate...

So I have a workbook that has 5 worksheets I want to use, but those sheets are huge and have data going back many years. This makes the queries, reports and dashboards in PowerBI cumbersome. Q1: Is there a way to get PowerBI to only import the last two years from a certain date? I say...

Good Morning Any ideas on how to do this in a measure.... Create a Ranking based upon a date from Earliest to Latest, where SALES DATE is Grouped and Machine is grouped. My Data looks something like this, but continues for upto 42 days and involves some 30 other fields in the table but...

Hey guys! I use this VBA since 2018, but now I want to use it in Power BI. Can someone please help me converting this from VBA to DAX, so I can use it? The VBA calculate the period between the two dates, only considering working hours (8h30-18h30), working days, discarding weekends and holidays...

Hi, I'm new to Power BI having come over from the Spotfire world where I would not have this issue. I have two tables (Main) and (Manufacturing) shown at the bottom of the thread. I would like to, compute a simple running total/cumulative new column of Rate by ID and Date and end up with a...

Hi I am building a dashboard for survey data and for reasons I am not quite sure I am running into a couple of problems. I have five questions that I want to focus on. My dashboard looks like so: 1) I wrapped the text box at the top with a blank box that i removed the borders. When I...

My organization has a report of the cumulative net income for each quarter for each year. I need produce a report in Power BI that pulls the quarterly net income rather than the cumulative net income. I currently have three DAX measures, one that pulls the current cumulative net income, a...

Hi Team, I'm trying to put an donut chart. In the legend field, the text gets truncated for some of the categories. I want to display the whole text. I tried with many formatting options. But couldnot find the correct option. Kindly help on this.

Hi Team, I have a column which contains values with week number and fiscal year.(Ex: WK-2 FY 22). I want to sort this column in visual. I guess we have to create a custom column. But I'm not sure of the logic? Can someone help on this?

Hello Mr excel Team, I created a new dataflow in my Power BI Workspace and added few entities to that dataflow from my desktop file. Then I refreshed the dataflow and after refresh is completed, I connected to my dataflow from Power BI desktop. Then I built my measures and I published the...

Hi, I know this sounds really dim of me but if I open up power bi, and then use 'get data' I can't see the option to open an actual pbix file? I alway just end up going to the folder it's saved in and opening up that way, what am I missing? Richard.

Hi All, I have a table below for which I need to change the background color for the values using DAX measure in conditional formatting. I have also added the output image with the conditions that I want to apply in the measure. I have already tried the measures that are already mentioned in the...

I have data in the format below (minus the far right column) EmailAddress CourseTitle Complete AllComplete 1@1.com Course1 true false 1@1.com Course2 true false 1@1.com Course3 false false 2@1.com Course1 true true 2@1.com Course2 true true 2@1.com Course3 true true Using DAX...