power bi desktop

Hi all I need some assistance please, I have a dashboard, where I have a date slicer, which is filtering fine on tables with a date, however, I have a staff list table which doesn't have a date to create a relationship with, but I am using the staff table in order to calculate how many people...

Dears, I need your help please in my issue," I'm new to DAX and I have tried many ways in this issue and nothing work with me", simply what I'm trying to do is to loop over my API to get the customer details. the API limit is 50 per page I manage to retrieve one page but when I wrote the...

Hi, Our daily sales data stored in Excel under the "sales" folder. I am trying to compare "Monday Last week's Sales" with "Monday this week's Sales" based on the date. I would like to create a new table to achieve my result - What are the item are newly added (unique) from Monday last week...

So I have a Power BI screen that i created via Power BI desktop and the connection is to SharePoint Online List. I have on my screen 3 elements, a) date slicer to select the date range to b table, B) Table, dynamic filters the data based on A date slicer. C) a card visual to sum the total of...

I have a chart that is created by summing quantities during a given month. Issue is that some months have no activity. How can my visual show all months that are null or 0? I have tried show all with no data selection in Powerbi but that shows all of the months in my dataset. I need to have my...

Hey guys, I want to create a calculated column that brings me the total sales quantity based on the week column, example:

Hello Everyone, Is there a way to show a date as "MM-YYYY" format in power query or in DAX. The actual data is in "DD/MM/YYYY" format. Thanks in advance. Best Regards,

I am new to PowerBi and need to know how to show two visuals with different date ranges on the same page. I have a slicer on my title page that allows someone to select the start date and end date of the report. On a few of my pages I have visuals for both 12 month (or what ever range they...

* I posted this on the excel forum, but since this also relates to power query I also am making a post here. Hey there, I am trying to make excel get automatically get data from a link (however the link changes based on certain inputs like ticker symbol, time intervals, to/from time) instead...

I am trying to graph some data from 5 years, on a line graph, and since I have the latest version of power bi, it has added data it has predicted, for the following years, and I would like to graph only the data I currently have on my database on power bi. How can I do this? Thanks.

Hello everyone, I am trying to make a visual that uses stacked area chart which has the average volume per week. The problem is that I have a date table and a column in it to get the week number "=WEEKNUM('Reported Date'[Reported Date]')". Whenever I am using this as an x axis, the type is...

I have just started using Power BI. I have created below tables: 1. Date Table 2. Purchase Table 3. Sales Table 4. Purchase Return Table 5. Sales Return Table 6. Scrap Table All tables are having a field of "Date". I want relationship of Date Table with ALL other tables as "Date" field is...

Hello I am facing a problem with filters when using a calculate function. To paraphrase an example, say I have a table of sales with a date and a sale method of either internet or store. In a second table, I would like to create a monthly summary of the number of sales - so I create a date...

I wish to create a measure, so I can dynamically populate a slicer, but the slicers don't accept a measure as input, so I don't know what to do. Any help will be greatly appreciated. Thanks.

So I have this formula in excel in my raw data =COUNTIFS([Date range],">="&(EOMONTH(Date,-1)+1),[Date range],"<="&EOMONTH(Date,0)) Power BI however doesn't have this function. I tried to use Calculate, but it is still confusing for me to understand some of these formulas. Can you please show me...

Hi to all, I managed to get in Excel desired % of time difference from column E, easy job just changed the Data Type to Percentage. What are we calculating is % of these TimeDifferences, one per one (other columns inconsiderable). The calculation I used is: MOD(D3-D2;1) and Column F (%) is just...

Hi Everyone, I'm trying to do some predictive forecasting with parameters but I'm coming across an issue when using parameters into the future. What i'm trying to do is forecast the amount of people on a waiting list in the future but this can be altered by using parameters which will remove...

Hello everyone! Hope you can help me on this Here's the problem: I'm trying to automate wih power BI something that takes me 4 hours to do. In a first source I get the following information (Excell file) * Reference number * Reference date * Customer * Country * Duration in minutes * Number of...

I am very new to Power Bi and need some help in solving a charting issue. I have multiple charts that use different date ranges in them. 13 month, 12 month, 6 month, 3 month and monthly. How do I have multiple date slicers or a master date slicer that controls multiples for my charts? I would...

Hi, I am doing a piece of work with one of my customers data, unfortunately they do not use a standard calendar the financial year is between 29th June 18 - 27th June 19. i have attached a link to the excel spreadsheet with the week commencing date / Month and period number. if anyone knows...