Removing a slicer interaction while still using the slicer value
In my report, a user will select a date using a date between slicer and we're only using the minimum date selected. This date can be any day of the week. I want to show the sales numbers for the entirety of that week. For example, if a user selects a Wednesday, I want to show the values for Sunday through Saturday of that week. I have tried several remedies, but it seems like I either show the days leading up to the selected day or the days after the selected day-- I have not been able to see the entire week at once. One attempt of a calculation was CALCULATE(sum(*redacted sales table info*),ALL('vw_D_Date'[date_value]),FILTER(*redacted sales table*,[MinimumSelectedDate])) where MinimumSelectedDate = FIRSTDATE('vw_D_Date'[date_value]) Any suggestions on how to solve this?
How to use different column value if slicer has selected value
My fact table is created like this: Date Carrier Score 1/1/2024 A 1 1/2/2024 A 0.98 1/3/2024 A 0.95 1/1/2024 B 0.98 1/2/2024 B 0.95 1/3/2024 B 0.9 I have a single dimensional table like this: Carrier Carrier Hide A Carrier 1 B Carrier 2 There is a single slicer which uses the [Carrier] value from the dimensional table. I'm wanting to create some functionality within the report that if someone selects a [Carrier] value, then it will return that [Carrier] value for that specific row, but will return the corresponding [Carrier Hide] value for each other row. I'm attempting to obfuscate non-selected rows with a different value if they are not selected, but leave the rows in place within the visual itself. So, if no slicer values are selected, it would return [Carrier]. If [Carrier] "A" is selected, it would return "A" for one row and "Carrier 2" for the next row, since [Carrier] "B" was not selected. Any help/advice would be greatly appreciated!
Impacting related slicers with DAX
Hello, I have following data model (fixed, cannot used both direction filters that solves my issue ) And my goal is to create report with 2 slicers (date and location) with condition that one slicer will involve second one (keep condition that current data model fix) so if I will choose range of values, then range of location will be also changes (based on the date range) I tried to put DAX field into location slicer, but it doesnt help, my guess was something like that: SlicerDate = CALCULATETABLE(Location, USERELATIONSHIP(Sales[ID_Date],'Date'[ID])) but getting error "The expression refers to multiple columns. Multiple columns cannot be converted to a scalar value." so may 2 questions 1) is it possible calculate dax measure and then assign it for slicer ? 2) If yes, what s the correct formula ? If no why I got this error it weird when calculatetable doesn t return table thanks !!!Can the Filter Function be used with Slicers?
Hi all, I have a report I'm developing and it works for company level but not when I want to use a slicer to investigate by depot/location. The background is as follows. "Sales" is direct calculation based on our weekly import and is working as expected. "Last Year" is a Dax expression: Calculate( SUM(Imports[SALES]), Filter( ALL(imports), Imports[Week No] =MAX(Imports[Week No])-100 ) ) So I've added a slicer to this sheet in order to restrict data to "Manchester" but what happens is the sales value as per the imports works fine, but the DAX expression doesn't incorporate the silcer and continues to show the Last Year value for the full company, (Note: I know there is a time inteligence function for "This Time Last Year" but this won't work with our current data.) So my question is, are Slicers and DAX expressions compatiable or do I need to change my use of the filter function? The solution needs to allow for other depot/location data to be selected in the slicer. For example, Should we switch the slicer from Manchester to London, I need the outcome of the DAX expression to update automatically and in accordance with the slicer. I look forward to hearing a response and developing my user of the filter function, thanks in advance. Regards, Chris
Making measures selectable in slicers
Dont know if this is posted anywhere but I had trouble finding it - If you want to make a slicer displaying measures from which you select you can do the following by creating a table: MeasureList = { ("Agree", NAMEOF('MainMeasures'[Agree]), 1), ("Disagree", NAMEOF('MainMeasures'[Disagree]), 3), ("Neutral", NAMEOF('MainMeasures'[Neutral]), 2), ("Strongly Agree", NAMEOF('MainMeasures'[Strongly Agree]), 0), ("Strongly Disagree", NAMEOF('MainMeasures'[Strongly Disagree]), 4) } Create a table using the above syntax the first bit is what appears in your slicer, the second bit is your measure table and measure name and the third bit is the order you want them to appear in. One created you add this to a slicer. Anyway - hope this is useful to somebody.Pass slicer date range to a variable
I am having trouble passing a slicer date range to a variable. I have two tables: 1. Before_Day_Key is used for my before slicer 2. After_Day_Key is used for my after slicer I have created variables that create the min and mix date for each of the slicers. Now I want to create a variable that has the date range of each slicer. What I am expecting is: VAR _periodBefore: 01/17/2023 - 03/20/2023 VAR _periodAfter: 03/28/2023 - 05/29/2023 Before_Day_Key table is here. After_Day_Key table is here. Can you help complete the statement: PED2 = VAR _minDateBefore = MIN('Before_Day_Key'[Business Date]) VAR _maxDateBefore = MAX('Before_Day_Key'[Business Date]) VAR _minDateAfter = MIN('After_Day_Key'[Business Date]) VAR _maxDateAfter = MAX('After_Day_Key'[Business Date]) VAR _periodBefore = VAR _periodAfter =Multiplying interactive slicers with columns.
Dear, I am looking to develop a power bi for our sales department for them to show the TCO for end customers. The benefit of buying a higher efficiency class. Power*Company cycle ...hoursperday*day in a year......* Energiecost.....(money/kWh)..... * difference in efficiency % |vs| Cost IE4-IE3. The problem is the energycosts per hours in a year. Power and efficiency are in a column. Hours per day, days in a year and energy cost are interactive slicers. I starting to believe this is not possible. Any tips? Im starting to lose hope.
Use slicer to filter column
I want to use my quarter year column as a slicer, when I select a single quarter year, the resulting outcome in the matrix table should give me the output as 'Selected quarter from the slicer and next two quarters' as shown in the below image. Can someone suggest any method or know the proper DAX for the following outcome?
