Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

Reply
cg1980
Helper I
Helper I

Data Model - Slicers does not show properly, table does.

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! 

 

 

 

cg1980_0-1623267855490.png

 

cg1980_1-1623268018758.png

cg1980_3-1623268167608.png

 

cg1980_4-1623268409604.png

 

 

 

4 REPLIES 4
parry2k
Super User
Super User

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_0-1623271197810.png

 

parry2k
Super User
Super User

@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

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.