Forum Discussion
Power Bi Custom Slicer
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!
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 _ RongtieIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 Reply
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 _ RongtieIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.