Forum Discussion
Pay Period Format
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 r...
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
The data i am having is something like
not as mentioned in here
its just the senario
