Pay Period Format

Question

I have created a PayPeriod Column as our requirements from startdate to end date for example

and i added the pay period slicer to the report as

But the client wants to see the value range for each PayPeriod as 9: 01/01/2023-01/14/2023 i wasnt sure how we can get this if any one knows please provide the ans

nathaniel_c · Answer

Hi&nbsp;Praneeth19&nbsp;,Please go to Power Query and merge your columns as follows:&nbsp;Duplicate your three columns first and use them to merge into one column.Beginning Example:
Remove all but the number in the Transform tab.

&nbsp;

Go to Add Column tab and Merge the dates using a "-"&nbsp;&nbsp;

Merge the two columns, making sure to click on the number column first and then the dates. Connect with ": "

&nbsp;Use the resulting column&nbsp; as your slicer.
Let me know if you have any questions.If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.Nathaniel