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!
Slicer of filter values are with data type (i.e) whole integer, But not getting search option?
Hi Team, Good Morning! Currently in my slicer of filter values are with data type i.e whole interger. and the values are shown with 12 digit number like below snapshot. Can you please suggest, If data type change it to text then we will get serach option, but it is not correct way. Please suggest how to fix this issue(suggest with snapshots please) or any DAX or any other way. Kindly help me to fix this issue. Thanks in Advance.
