Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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
Solved! Go to Solution.
@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
@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
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
113 | |
89 | |
84 | |
76 | |
64 |
User | Count |
---|---|
135 | |
111 | |
98 | |
98 | |
92 |