Forum Discussion
How to create a filter that controls the DirectQuery directly?
That's how Direct Query works anyway. What have you tried and where are you stuck?
Hi! I am currently stuck on two aspects. I am currently trying to create a relative date visualization slicer for a time filter I am trying to make. I created Start Date and End Data parameters to be able to manipulate the data from the DirectQuery directly on Power Bi.
This is how it currently looks but I would like for it to look like this:
My other question is how to join on two direct queries. I want to be able to filter based on a column called Organization which is available on both my columns. Table A and B are joined Many to Many. This slicer is based on the Organization of Table A so when I try to filter the data, my information from Table B breaks and this pops up:
However if i remove that filter, it shows up just fine.
Any suggestions?
You can either hand over a date range to the parameter (and handle that in your Power Query code) or use separate tables for the Start and End date ranges. I would suggest the first option.
Here is one possible implementation Chris Webb's BI Blog: Handling Multi-select In Power BI Dynamic M Parameters (crossjoin.co.uk)
I already have separate tables for the Start and End date ranges as it looks in the first picture of my last reply. My question is that if I hand over a date range to the parameter, will the Start and End dates be selected as two individual dates or will it take all the dates between the two.
Example:
Selecting Start date= 1/1/2024
Selecting End Date = 6/1/2024
will it only show me dates from 1/1/2024 and 6/1/2024 or will it give me all the data points from 1/1/2024-6/1/2024. I would need it to get all data points from 1/1/2024-6/1/2024.