Forum Discussion
Power Bi Custom Slicer
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.
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.