Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
This feels like a simple thing, so maybe my brain is just not on, but I could not find a quick solution -
We have a few different Marketing programs, and I would like a slicer filter on one of my dashboards to filter down to just products from a particular category. On the item card, I have a column for each of the programs. Some items are in multiple programs, so I can't get it down to a single column to use for the slicer. I tried creating a separate table with the list of programs, but I can't have multiple relationships from that table to the Item table, or even if I create multiple intermediary tables.
I can get around this by having a separate slicer for each program, but it would be great if I can have a single slicer that can reflect the list of different programs.
Thank you!
@rsadagopal , I agree with @AbbasG , need more information. Buts based on what I got check if this can help
https://amitchandak.medium.com/power-bi-search-text-parts-in-text-ad2f9783ffa2
If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
@rsadagopal Hi, can you provide sample data to work with (after removing all the sensitive information)
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
User | Count |
---|---|
86 | |
85 | |
68 | |
67 | |
63 |
User | Count |
---|---|
210 | |
118 | |
116 | |
81 | |
74 |