Skip to main content
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Not applicable

Slicer that filters two columns



Screenshot 2022-07-04 163203.png


I have a table with the column month numbers (which is connected/related with my main fact table) and two calculated columns YTD and FY. Now i want to creATE a slicer that has two options: Year to date (YTD) and Full year (FY). My problem is that the slicer options are from two columns and i dont know how to handle that. I have read an article form sqlbi "Creating a slicer that filters multiple columns in Power BI - SQLBI" but i didnt help me further.


help is much appreciated. Thank you 🙂

Not applicable

Thank you very much for your help @amitchandak 

I tried to follow your suggestion but i dont really get your solution. Why sould i create a measure when you can't put a measure in a slicer?

With "Slicer[value]" in your measure do you refer to the column of the new table (with the two row values "Year to 

date", "Full Year")?


Screenshot 2022-07-04 171751.png

Super User
Super User

@Anonymous , Have a new table with two row values "Year to date", "Full Year"


then have a measure like


measure =

var _filter =

Switch( selectedvalue(slicer[value])

"Year to date",filter(Table, not(isblank([Year to date])) )

"Full Year",filter(Table, not(isblank([Full Year])) )



calculate(sum(Table[Value]), _filter)

Helpful resources


Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.