How to get an in-between slicer to only show values which are filter in Date Table rather than MIN/MAX of Date Table?
I have a Date Table (Thanks to Sam Nseir!) in place and my Fiscal Month is from 21-22 each month.
When I select a fiscal month these are the values I get in this format dd/MM (This is a calculated column on the Date column marked in Date Table. This is for March selection.
I want to make this as an in-between slicer but when I use the Date column marked in Date Table in the slicer the date range it shows always lies in the range of MIN(DateTable[Date]) and MAX(DateTable[Date])
How can I make an in-between slicer so that when I select March I get a slicer with a range of values shown above that is 22 February to 21 March?
It looks like it already works for me. If you go to edit interactions on the ribbon and change it to filter the visual, you get the desired behaviour don't you?
- Power Query Conditional JOIN - JOIN with WHERE clause
- Power BI: Count the number of times a text appears in each row
- How to sort weekdays in Power BI based on today
- What are the minimum Azure permissions required to publish a Power BI report using "App Owns the Data"?
- Filter multiple visualizations to exclude values that have already been excluded
- How to count direct and indirect test cases for Features, Requirements, and Change Requests in Power BI using DAX?
- Group average as a baseline & individual variance to baseline
- DataFormatError whenever I filter a column
- How to structure input to use PowerBI REST API: multi-value parameters
- Data missing from basic visual in Deneb (vega-lite)
- Microsoft Power BI REST API PowerBINotAuthorizedException
- Filtering values on one visual affects filtering on second visual
- PowerBI Embed in Angular "User Owns Data" | Getting InteractionRequiredAuthError: AADSTS65001 while generating powerbi access token
- Displaying a Fixed Timeline in a Power BI Line and Clustered Column Chart with Slicers
- Integrate PowerBI report using 'embed for customer approach' to angular application which use OKTA to authenticate
- Why do fields still show in PowerBI when I have them filtered in the model?
- How to sort a line chart X-axis by a different column than displayed
- Row Comparison in PowerBI
- PowerBI Slicer showing single value from group of values
- Sorting Months in a Power BI Visual by Fiscal Year and Month
- Power BI report of excel data source
- PowerBI REST API get reports
- Reference another table when getting data from Python in Power BI
- Power BI - Powerpoint Export is Not even Showing
- Is it possible to schedule refresh in Power BI with Windows Task Schedule?
- PowerBi measure where the total is based on the legend and adjusts total for selected slicer
- DAX problem - The expression refers to multiple columns. Multiple columns cannot be converted to a scalar value
- How do I create a bar plot histogram of a parameter in power BI
- How to show a colum total in a Power BI matrix visualisation that has implicit columns based on values?
- power Bi count the number of completed tasks per bucket