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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Anonymous
Not applicable

Slicer that filters two columns

Hello, 

 

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 🙂

2 REPLIES 2
Anonymous
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

amitchandak
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])) )

)

return

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

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

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

MayPowerBICarousel

Power BI Monthly Update - May 2024

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

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.