Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
I have a slicer which is coming from Calendar table it has dates from 01-01-2015 to 12-31-2060, i have limited sllicer to year 2020 & 2021 with
Filter passed on above visual is
If I deselect June (Current Month) then it should show data only till May 2021 but when I deselect june It is showing like
But I want it to be till may only. I want to achieve it with Heirarchy slicer
@Anonymous
Please get familiar first with how to properly work with dates and times in PBI: Standard time-related calculations – DAX Patterns
Then, you can make use of this hint: If a measure returns BLANK, it will not be shown in a visual. Also, you can filter a visual through the Filter Pane and make use of any measure you find useful.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
15 | |
11 | |
11 | |
10 | |
10 |
User | Count |
---|---|
19 | |
14 | |
13 | |
11 | |
8 |