How to make a graph understand that the week number is next year (to make the date sort right)?
Hi, I have this data: And I have made this graph - which shows completed sales and expected future sales. This works great for when I use the "Date" field, but I want it on week level, and when I do that it looks strange (see picture below), because Power BI doesn't understand that week 1 is next year, and hence is after week 52. Is there a way to make it understand that week 1 is next year? And hence that the graph looks more similar to the one with "Date"? Thanks in advance, highly appreciate it 🙂
How to store data in a table based on month calculation
Hello Everyone, I am posting this request again as i was not able to get the help please find the question and details below So I have Table 1 created out of data scores like below Table 1 Issues Name&Percent Sales 82.86 Prod 21.27 Eng 6.06 Quality 1.09 Admin 1.05 Avg of issues for Sep 22.47 In next month Table 1 one will have different value Issues Name&Percent Sales 85.86 Prod 25.27 Eng 7.06 Quality 1.09 Admin 1.05 Avg of issues for Oct 24.06 So I want to create another table which can store month wise average data based on Table 1 Average Table Avg of issues for Sep 22.47 Avg of issues for Oct 24.06 Thanks and Regards Premlata @memmbers
Improve visual table - problem with sum by dates
Hello everyone! I'm new in power bi (expert in Excel) and I did an dashboard based on varied data sources (Share Point List, Oracle and more). My dashboard presents the total manufactre work orders on the machines in my factory and also the invalid items that the QC department reject. When the user pick a date to slice, the data that need to show is the work order that active in the machine, according to the slicer date, and the total amount manufactre an the invalid item for this day only. My problem is when I make an visual table that need to shows the OEE of the machine in the amount of the invalid items, the visual table shows the total amount for the specific work order but nit according to the date slicer. I thought maybe to creat an marge table, but the data that shows for the invalid items is the total amount of all invalid items from day one. Here is an screensot of the visual table: Here is an screenshot of the invalid table according to the highlight exmple in the previous screenshot: Here is an screenshot of the marging table and the sum of the invalid items column formula:Average Last 6 months accumulated
Hello dear community, I come to you so that you can help me with this DAX calculation. I need a Calculated Column to show me: the average of the last 6 months accumulated for each collaborator (in case the collaborator appears> = 6 times in the year); or in the event that the employee in the current year period appears less than 6 months, showing the average based on the number of months that the employee has been in the company in the current period, for example: Year Filter: 2021 Current month: May2021 (5) Seniority of the collaborator to May2021: 3 months (that is, the collaborator appears 3 times until May, if in June it becomes active, the collaborator when we are in June then it will appear 4 times, and so on) So the average will be = (Mar + Apr + May) / 3 Also consider that I already have a calendar table in my Power BI. Here I have an example sample of what I want exactly (column "Average Last 6 months), you can download the file here: I also leave the extract here: I read them, I hope they can help me as soon as possible. and thank you very much in advance. Nestor ReyesQuery IDs from previous quarter
I'm trying to make a DAX query which can pull all the customer ID from previous quarter and their respective data columns based on slicer selection but I'm not able to figure out the right function to use here. I've tried using SUMMARIZECOLUMNS and GROUPBY after looking up at some examples but the syntax doesn't seem to be correct. For Eg: If a user select EffectiveDate: December, 31, 2020 from the dropdown, the table should have IDs of previous quarter ( EffectiveDate: September, 30, 2020). I know how to do it in sql/python but not sure what is the right approach/function to dynamically query rows based on filter selection. These are the final table columns I'm trying to extract. I've attached the pbix file for reference. The table I have used in filtering the current quarter selection and not dynamic. Note: EffectiveDate will always be last day of quarter in my case. PBIX Link: https://drive.google.com/file/d/1A-l-uQpk3enSsAOn5IfFux4NcRE18p_V/view?usp=sharing Let me know if there's any way to achieve this. Thanks
