Visualisation (Slicer and Button Slicer)
Hi everyone, I hope you all have a nice day. I want to ask (pictures attached), I gave an example of me using visualisation of "Button Slicer (Top)" and "Slicer (Bottom)" in the picture, I have a table where I have Reporting Date column then I make custom column for the quarters and months. The "Year" in the slicer is from Reporting Date hieararchy (Year), but the quarter and month in the slicer, they both are custom column that I made from the Reporting Date column (so they are not the hieararchy of "Reporting Date"). My questions (I don't mind if you answer with "Slicer" visualisation or "Button Slicer" visualisation): In Picture 1, If I select Q1 and it turns grey, how do the visualisation slicer for months turns black (for Jan, Feb, Mar) without me selecting the Quarter slicer? In Picture 2, If I select any month (for example: Aug) and it turns black, how do the visualisation slicer for quarter turns grey (Q2) without me selecting the Quarter slicer? In Picture 3, If I select Year "2025" and it turns black, how do the visualisation slicer for quarter and months also turns black without me selecting Quarter and Month slicer? Please kindly help me answer my questions. Thank you in advance. God bless. 😊🙏
Slicer which choose between specific time periods
We have a bunch of visuals displaying varius Order details from our Order_Table with slicers where you can filter on specific time periods from the Calendar table. For example selecting July shows totals amount of orders in the visuals for that period. Now my Manager wants to be able to Slice orders on specific campaigns as shown in the campaign table. How do you Create preset time periods in the slicer? (Sadly I only have access to the old slicer fyi). Tried something like this but as I bound the table-relationship between Campaign[Starting_date] to Calendar_Table[Date] it ofcourse only slice total orders for the specific starting date of the campaign ( 05-02-2025 for campaign 2 for example) instead of the total campaign period. Order_Table Order_ID Order_Date Ship_date 1 01-07-2025 01-07-2025 2 01-07-2025 02-07-2025 ... ... ... Relationshsips Calendar_Table Date Year Month 01-07-2025 2025 July 02-07-2025 2025 July Campaing_Table Campaing Year Month Start_Date End_Date 1 2024 Dec 15-12-2024 31-12-2024 2 2025 Feb 05-02-2025 17-02-2025 3 2025 July 01-07-2025 22-07-2025
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?Slicers not visible in focus mode
Hi, I want users who view the reports in Report Server to be able to see which slicer choices are in use when they enter Focus Mode and choose to print the page. Or is there any way a user can print a specific visual with all the data visible along with the slicer choices that are in use? Can I somehow custom make Focus Mode through PBI Desktop? BR Emma
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.
