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
DavidPorTodos
Helper I
Helper I

Slicer Filtering through List of values

image.jpg

Hi there, 

I am Not sure how to phrase my question but I hope through the examples to clarify it.

I would like to be able to build a slicer where years and quarters are displayed (format: 2022 Q1) filtering my table through the column "period" where values are a List of values separated by semicolon. (2022 Q1; 2022 Q2)

Could you suggest on how to proceed to achieve it?

 

Many Thanks

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

2 REPLIES 2
amitchandak
Super User
Super User

@DavidPorTodos , Are you looking for an example like

 

Power BI- Text Part slicer to filter/search text - https://youtu.be/MKKWeOqFG4c

https://medium.com/@amitchandak/power-bi-search-text-parts-in-text-ad2f9783ffa2

Hi @amitchandak 

thank you for your answer.

it Looks like your solution might work.

i actually have more complex data Model where year and Quarter are actually Used to Filter more Tables at once. I created a dimdate with just year and quarters on it linked to all tables. I believe i could use it and create a middle table with the keys Link to dimdate and then to the table with my data.

I am just Never comfortable in using Many to Many relationship 

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.