Forum Discussion

cg1980's avatar
cg1980
Helper I
5 years ago

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! 

 

 

 

 

 

 

 

 

General Comment
Need Help
Show and Tell

4 Replies

  • parry2k's avatar
    parry2k
    Super User
    5 years ago

    cg1980 seems like you are adding columns from different tables in the slicer which are no directly connected. is that correct?

    • cg1980's avatar
      cg1980
      Helper I
      5 years ago

      Hi parry2k  thanks for looking on this!.. the tables are connected , you can see it on the figure 1

  • parry2k's avatar
    parry2k
    Super User
    5 years ago

    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.

     

     

    • cg1980's avatar
      cg1980
      Helper I
      5 years ago

      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.