Pay Period Format

[Praneeth19]

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]

Hi @Praneeth19 ,
Please go to Power Query and merge your columns as follows: 
Duplicate your three columns first and use them to merge into one column.
Beginning Example:

Remove all but the number in the Transform tab.

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

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

 Use the resulting column  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

[Nathaniel_C]

[Praneeth19]

The data i am having is something like 

not as mentioned in here

its just the senario