Forum Discussion

kaushikhalvadia's avatar
kaushikhalvadia
Regular Visitor
3 years ago

Use slicer to filter multiple column

Hi, I am a beginner and learning Powerbi. I'm creating this is 3rd report 🙂 

 

Below is my SQL query for the report which gives me the expected and accurate output. 

Now, I want to pass the StartDate and EndDate values from the slicer(Between types)

 

Can someone please tell me how to achieve this?

 

PS. I can pass and fetch date columns/parameters in any format. Currently, I have passed the dates as varchar.

 

 

Thanks for your help!

 

Need Help
Tips and Tricks
Tutorial Requests

3 Replies

  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    Community Support
    3 years ago

    Hi, kaushikhalvadia ;

    As far as I know, you can use DAX to implement, Power BI has data processing functions and dynamic display of results, if you can share a simple example (scenario) and hope to output the result it is better, in order to solve your problem faster.
    Looking forward to your reply!


    Best Regards,
    Community Support Team _ Yalan Wu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    Community Support
    3 years ago

    Hi, kaushikhalvadia ;

    Sorry, can you share a scene and the result you want to output? So that I can better use DAX testing.


    Best Regards,
    Community Support Team _ Yalan Wu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.