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-2025Slicer enabling user to choose dataset for several visuals
Hi PBI community 😊, Users of my report would like to be able to choose between two different datasets for several visuals. They want to choose between two types of calculation rules/datasets depending on their needs. Is there a way to create a slicer to choose between two different datasets ? I was thinking of using bookmarks but this feature does not work well when the report is exported on upslide (powerpoint), which is needed by the users. Thank you for your help Gaëlle
Timeline 2.1.1 has a bug
The custom visual "Timeline 2.1.1" (the one I'm using to filter a table visual) picks the date field and not the auto hierarchy as built-in slicers do. Take a look at the two imagens below which explain easily what is happening. The Power BI slicer automatically picks the autohierarchy and filters the table visual but Timeline 2.1.1 does not and so it doesn't filter tha table: I tried to add the autohierarchy to the Timeline 2.1.1 visual, but it just adds the year, and when I try to filter the table visual with the autohierarchy year added still it soesn't filters the table. Let me know if I'm doing something wrong or if in facts is a bug. Thank you everyone.
