Dynamic Filter Based On Selected Date Slicer
Hi all, This is a mock screenshot of a monthly report to track # of phone calls we make. We operate on a fiscal year from June 1 to May 31. Referring to the picture below, I am stuck on how to calculate future months phone calls (not including the current month which is the selected date slicer value "August 2022") but limited to the end of our fiscal year. For example, next month I'd like to change the slicer value to "September 2022" & have the "Future Calls Until End of Fiscal Year (Not Including Selected Month)" calculate the number of phone calls made in October-May of this fiscal year, and it would dynamically calculate future phone calls after the current month based on the SELECTED month in the slicer. Also, I have a very extensive date table like year/month/day offset columns, Month Year, Month Year Sort, etc. I got many of these calculated columns off Power BI forums so I added as much as I could so it may help in the future. I hope this helps, any tips on how to navigate this issue? Thanks in advance & appreciate the help.
Create Filter to apply to matrix so it will only show compliant IDs
Hi everyone, I'm currently working with employees' IDs. I'm trying to have a matrix that will only show those employees who worked more than 44 days every quarter that the Matrix is showing (based on the slicer selection). I already grouped all my data into quarters and added a column (Compliant Q) to identify those quarters for each ID that is compliant with this condition. This how the backend table in my model looks like: I then used "Compliant Q" column to filter out the non-compliant quarters. And this is how the Matrix looks like: I would like to create a measure that could do what the Matrix's "Row Subtotal" and the slicer combined are doing. I want to have a measure that sums total number of compliant quarters by ID based on my selection, to use it as a filter for this page in my report. I want my matrix to only show those IDs in which the 12 selected quarters are compliant with the 44 days condition. I also want this to be dynamic, so it will update based on the user's selection. In case the user selects 20 quarters I would like the matrix to only show those IDs in which the 20 selected quarters are compliant with the 44 days condition and so on... In the example I shared the matrix is also showing IDs that have less than 12 compliant months. I want to avoid that. Does anyone have any ideas? I would really appreciate the help! Thanks in advance, Michelle
line chart shows blank values
hello, i have created a measure that concatenate numerical value and string . it shows data correctly in a table visual but when i use a line chart all data become blank table: line chart: the measure i created depends on a filter, when filter is selected measure will display value without a $ sign and when filter is not selected measure will display value with $ sign. the string in my measure was to add the $ sign part to the number
Calculating a Forecast looking at Previous Values
Hello, What I am trying to do is calculate a forecast using the previous row's number. So for the first row of the column "forecast" the formula is summing all the numbers in column "S." Then for every other row it uses the previous "Ending" value. Just need to know if/how this would be possible in Power BI. Date S U G Forecast Ending (U-G+Forecast) 1/01/2020 0.08 0.24 0.68 4.86 -3.94 31/12/2019 0.53 0.34 0.96 -3.94 5.24 30/12/2019 0.24 0.39 0.32 5.24 -4.53 29/12/2019 0.60 0.88 0.58 -4.53 5.99 28/12/2019 0.84 0.52 0.13 5.99 -5.34 27/12/2019 0.60 0.29 0.01 -5.34 5.64 26/12/2019 0.71 0.62 0.12 5.64 -4.90 25/12/2019 0.71 0.30 0.59 -4.90 5.78 24/12/2019 0.55 0.62 0.03 5.78 -5.13Filter a table visual based on the latest data update
Hello guys! I have a dashboard which it's data is based on a position for open items, so every day I have a programmed routine that downloads the data into my dashboard and it get's updated. Considering the data is for open items, one specific item can appear multiple times until it's cleared, so I've been working only with the latest date and keep the past information as history. Here's a glimpse of the dashboard: On the top right, I created a measure that gets the latest date on the data and all the other measures also use that information to display it's info (based on the context). I also created a line chart so people can see the data history and to be able to select a specific date in time, so when I interact with a data point on the line chart all the data get's updated to that specific position/context in time. Everything works fine, except for one particular visual. As you guys can see, there is a table visual; the highlighted column on the table specifies what database the user is seeing the information and it's not having the same behaviour as the other visuals on the dashboard, because it's displaying all the data when it should only bring data from 2020-03-27; I have a few columns on that table that are actually measures, the same as the ones being used on the other visuals, that get's the maximum date from the context, but they are not filtering the data on the table. When I select a specific date on the line chart, as obviously expected, the table gets filtered alright, as the other visuals, but what I need for it to do is, when nothing is selected, to display only the data from the latest date available. Any thoughts on the matter? I'm pretty sure I can solve this with DAX, but everything I tried works with every single visual available, except for tables. Thank you very much!
