Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
Hi There!,
I have a model with some of the tables listed on figure 1, this model works quite well with all calculations we need. Figure 2 is an exaple of a table shwoing data from BUSINESS CYCLE, BUSINESS PROCESS, PROCESS-RISKS and RISKS, So far so good.
When this same data wants to be represented as slicer we got the message "You are using fields that dont have a supported set of relationships" Figure 3, If remove the attribute Risk description from table Risk seems to work, but i still need this attribute on the slicer Figure 4 , any thought what would be the issue that does not allow to represet table1 as slicer?
all the best!
if tables are not directly connected, and you are using columns from different tables it will not work
for example, if you pick a column from Business Cycle and add another column from Risks table on the same slicer it will not work because these tables are not connected directly.
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
Hi !, let me give you an example on the same model where you can see that even though fields are from different tables the slicer is able to manage those. This is why i can not find a logical explanation to the problem reported.
@cg1980 seems like you are adding columns from different tables in the slicer which are no directly connected. is that correct?
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
Hi @parry2k thanks for looking on this!.. the tables are connected , you can see it on the figure 1
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
81 | |
76 | |
61 | |
37 | |
33 |
User | Count |
---|---|
101 | |
56 | |
51 | |
45 | |
40 |