Skip to main content
cancel
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

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
Fabcon_Europe_Social_Bogo

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.