Extracting data from hotel booking website

[Anonymous]

Hi,

I've extracted data of hotel names and prices from booking.com. My goal is to create a chart with a date filter that enables me to see hotel prices by selecting the dates of my stay (e.g 12/27/20 - 12/29/20). So far my query works by outputting the hotel prices when I enter in the parameters (hotel stay dates), but I'm stuck on how to proceed from here in order to create the data visualizations. How do I apply this query to my entire dataset to make it dynamic for analysis? Is there a way to make my dataset for visualization dynamic (upon entering stay dates)? My query and parameters are shown below:

[v-yuaj-msft]

Hi @Anonymous ,

If you have a "date" field in your table, I think you can create a slicer that applies to the entire report.

Result:

Hope that's what you were looking for.

Best Regards,

Yuna

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Anonymous , refer if this can help

https://www.thebiccountant.com/2017/03/22/use-slicers-for-query-parameters-in-powerbi/