Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
Hi Guys,
I need to filter out a item in my date slicer . I know that if this was a visual it would be easier since visual filter was there . In the below image i dont want to show blank. Another option i saw was that i bring in another slicer and select all values except blank and hide it. Is this the best option available ?
Solved! Go to Solution.
@ajin Pleae try to create a "New Table" with single column "Year" using below DAX (Which will be source for your slicer) and then create a relationship between this new slicer table and the main table (in this case it will be on Year field).
TestYear = FILTER(DISTINCT(_DimDate[Year]),[Year]<>BLANK())
Proud to be a PBI Community Champion
@ajin Pleae try to create a "New Table" with single column "Year" using below DAX (Which will be source for your slicer) and then create a relationship between this new slicer table and the main table (in this case it will be on Year field).
TestYear = FILTER(DISTINCT(_DimDate[Year]),[Year]<>BLANK())
Proud to be a PBI Community Champion