Power Bi Custom Slicer

[Joe_Sharman]

Hi there, 

I would like to create a custom date slicer within Power Bi based on Periods my company uses which are not regular. I believe I need to create a table with my periods in (example below - Dates in DD/MM/YYYY format) and conect to my orders table which has the order creation date within it. But i'm not sure this is definitly correct or where I would need to go from there. Can someone help with this. 

Period Name | Period Start | Period End 
P09 22 - 23      13/11/2023  11/12/2023
P10 22 - 23    12/12/2023  08/01/2023
P11 22 - 23    09/01/2023  05/02/2023

Any help is greatly appreciatied!

[Anonymous · Accepted solution]

Hi @Joe_Sharman ,

Please have a try.

• Create a table with your periods in Power BI Desktop.Make sure the Period Start and Period End columns are formatted as Date data type.
• Connect the Periods table to your Orders table using a relationship. You can either use the Autodetect option in the Modeling tab, or create a relationship manually using the Manage Relationships option in the Home tab.
• Create a slicer visual for your report, and then select the Period Name column from the Periods table as the Field value.

How to Get Your Question Answered Quickly 

If I have misunderstood your meaning, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards
Community Support Team _ Rongtie

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.