Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Slicer filtering based on selection and report interactions

Hi Team,

 

I have come across an issue where I couldnt able to resolve . I have explained the problem in detail .Please look into it and help me in resolving the issue. 

 

I have two tables in Report page as shown in screen shot . Also I have 2 slicers based on Attributes and Values columns in Query . If I select "Hardware Management controller" as a value in Slicer ,it is showing data in one table and an empty records in other table which is absolutely correct. However, Once I select some value in other slicer(Value) , it should select values in respective table and associated values in other table.  I couldnt able to edit the interactions in the required way.  Please help me in fixing this issue. 

 

 

How I want is ?  It is not happening because this is just one query . 

 

 

Need Help

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Can some one help me on this please ?

  • v-piga-msft's avatar
    v-piga-msft
    Icon for Resident Rockstar rankResident Rockstar
    7 years ago

    Hi Anonymous ,

    Normally, if you filtered with two slicer, the result will be the filtered value based on the two slicers. So when you select "Hardware Management controller" as a value in Slicer, it will show the value based on this selection, when you select another option in Value slicer, it will be filtered the value based on your first selection.

    I have a little confused about your scenario.

    So what is your desired output for slicers? If it is convenient, could you share the data model which could reproduce your scenario and your desired output so that we could help further on it?

    Best  Regards,

    Cherry

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Hi Cherry,

       

      Thanks for replying . I have attached the data model of my report . In each of those 3 main tables on top(HMC,Managed Systems and Servers/LAPRs) , Columns called Value and Attribute are combined from this 3 tables and used as a slicers . 2 tables are created using a DAX formulae to combine them .  See below . 

      Table =
      DISTINCT (
      UNION (
      SELECTCOLUMNS ( 'HMC', "Attribute",HMC[Attribute]),
      SELECTCOLUMNS ( 'Managed Systems', "Attribute",'Managed Systems'[Attribute] ),
      SELECTCOLUMNS ( 'Servers/LPARs', "Attribute",'Servers/LPARs'[Attribute] )
      ))
       
      Table1 =
      DISTINCT (
      UNION (
      SELECTCOLUMNS ( 'HMC', "Value",HMC[Value]),
      SELECTCOLUMNS ( 'Managed Systems', "Value",'Managed Systems'[Value] ),
      SELECTCOLUMNS ( 'Servers/LPARs', "Value",'Servers/LPARs'[Value] )
      ))
       
      So this table and table1 are my slicers as shown in previous screen shots. 
       
      Now, what I am trying to acheive is - When I select "Hardware Management controller" as value in slicer , it should show only first table . Now, When I select a value from second slicer that belongs to first table (Hardware Management controller) , that same value should be shown in first table and associated records in other 2 tables. 
       
      This tables are associated to each other with the help of this Managed Systems table which is in center. 
       
      Hopefully this information helps .