Hi Expert, How can I resolve a problem with a Power BI slicer or custom slicer?
Even after configuring the slicer to display values from 1 to 5 and applying a filter to exclude 0, the issue persists, showing the value for 0 when I select 1. Please note that using a page-level or visualization filter to exclude 0 is not a suitable solution in this scenario. Data: Visual: Slicer with matrix, Exclude 0 from slicer when slicer make it to 1 still showing value for 0. Any suggestions on how to resolve this? Thanks in advancedHide future year(s) from slicer visual
I placed the following "Year" ("Ano") slicer on a report page by adding the year column from the date table 'dData[Ano]': It however shows a year in the future, since 'dDatas' goes all the way through the end of 2024 (it needs to continue this way). But I need this slicer to show only the current year plus all available past years. How can I set a dynamic threshold that could make the slicer hide this and any other future years that might come up? I tried playing with the filter pane but couldn't find anything that could get that done. One of the filter pane options is to set a top or bottom value, so I created a measure DISTINCTCOUNT( dData[Ano ) to dynamically set this value, but when I place it on the well the "Apply filter" is still greyed out so that's also not working for me. And I tried creating a measure with GENERATESERIES but the slicer "Field" pane won't even take this measure when I select it. I get the sense this should be a simple fix, but I ran out of options to the best of my (limited) knowledge and really need that future year (2024 on this case) gone from the slicer. Please help!
