Pivot using Date slicer/parameter

[gingersnap]

I have a pivot table I created using 2 fields. I would like to use a slicer so a date range can be requested. I dont know if this is possible since a date field is not part of the pivot. I am new to PowerBI so any help is welcomed. Thank you

[Anonymous]

Hi, @gingersnap 

Thanks for Kedar_Pande and parry2k's replies. What is your current data holdings, can you share your non-sensitive data and what you expect to achieve, if it can be in the form of a picture it will help us to better understand your needs. There may be other ways to realize your requirement.

Best Regards,
Yang
Community Support Team

[gingersnap]

Thank you for replying. It is solved. I will mark it as such. I do have another issue but I will post it separately

[Anonymous]

Hi, @gingersnap 

Very happy you were able to solve this problem, what is your current solution? You can share it and accept it as a solution to enable people with similar problems to find it faster. Thanks for your understanding.

Best Regards,
Yang
Community Support Team

[Kedar_Pande]

@gingersnap 

1. Ensure the date column is present in the data you used to create the pivot. You don’t need to display it in the pivot table, but it needs to be part of the dataset.
2. Go to Visualizations, choose Slicer, and drag your date field into it.
   This will create a slicer visual that allows you to filter based on a date range.

💌 If this helped, a Kudos 👍 or Solution mark would be great! 🎉
Cheers,
Kedar
Connect on LinkedIn

[gingersnap]

Thank you for replying. Unfortunately it is not part of the pivot. Thats my issue. 

Is there anyway around this? Do I just need to create a separate report and use a parameter? Since I am creating a pivot, I cant use a direct query, so I am not sure how to use a paramter.

[parry2k]

@gingersnap cannot download, it is saying access is denied.

[gingersnap]

Good morning. Any luck? If not please do not spend anymore time on it. I have another issue I am going to post. Thank you VERY much for your willingness to help.

[gingersnap]

I dont know how to unlock it.

[parry2k]

@gingersnap It will be easier if you share pbix file using one drive/google drive with the expected output. Remove any sensitive information before sharing.

[gingersnap]

I just changed the access. Please try again

[gingersnap]

https://drive.google.com/file/d/1hQLbA2DQXswVEAem_s32Cz6ZPJ4vRZJv/view?usp=drive_link

The data is from a test database. Page 2 has what the final pivot should be. I very much appreciate your help.

[parry2k]

@gingersnap Yes keep the date in the table, create a pivot without the date column, and use the date for filter.

[gingersnap]

Thank you so much for the quick reply. 

I remove columns, including the date column, before I create the pivot. Can I leave the date field in, create the pivot? Can I create a pivot once I get to the report/visual area?

[gingersnap]

Since I am new, I dont know how to keep the date in the table but out of the pivot. Can you explain how I can do this?

[parry2k]

@gingersnap If you have a date column in your model that you wish to slice on, it doesn't need to be on the visual. It all depends on how your model is created, and what kind of relationship have between tables.

in the end, the column you want to slice on doesn't need to be part of the visual.