Forum Discussion

srana's avatar
srana
Frequent Visitor
4 years ago
Solved

Filtering Matrix visual.

I have a matrix visual which has 3 columns and 3 slicers to filter the matrix table as shown below:- 
 

Each column should be filtered out by its respective slicers and should not affect other columns.

All the field for the columns and slicers is coming from one table.
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi Anonymous ,

    I am replying on behalf of srana .

    Attached is the sample pbix file which is used here.

    Here is the situation -

    I have two tables i.e is DATA_1 & DATA_2 which has Field, region, version, hop & counts columns.

    In transform data, I have applied pivot step so that hop_name can get the counts respectively.

    After that, I append both the tables. 

    On report side, I need three slicers - one is for Region, version_for_Hop1 and version_for_Hop2 (This is all coming from append table)

    I took table visual to show the fields and hops.
    This is how it looks like -

    The problem is - 

    When I select V1 from version_for_Hop1 and V4 or any other items from version_for_Hop2 , the table turns out blank.

    Expected Result is- 

    When I select V1 From version_for_Hop1 and V4 from version_for_Hop2, it should show respective data in each columns.

     

3 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    4 years ago

    srana , You have to create measures to use the values from these slicers and ignore from others

    If they are same or joined table- means filter when select then create like

     

    calculate(Sum(Table[Value), removefilterS(Table[Version_V2]), removefilterS(Table[Version_V3]) )

     

    if they are independent slicer then try measure like

    calculate(Sum(Table[Value),filter(Table, Table[Version_v1] in values(Version1[Version_V1]) )

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi srana,

    Can you please share a pbix or some dummy data that keep raw data structure with expected results? It should help us clarify your scenario and test to coding formula.

    How to Get Your Question Answered Quickly  

    Regards,

    Xiaoxin Sheng

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Hi Anonymous ,

      I am replying on behalf of srana .

      Attached is the sample pbix file which is used here.

      Here is the situation -

      I have two tables i.e is DATA_1 & DATA_2 which has Field, region, version, hop & counts columns.

      In transform data, I have applied pivot step so that hop_name can get the counts respectively.

      After that, I append both the tables. 

      On report side, I need three slicers - one is for Region, version_for_Hop1 and version_for_Hop2 (This is all coming from append table)

      I took table visual to show the fields and hops.
      This is how it looks like -

      The problem is - 

      When I select V1 from version_for_Hop1 and V4 or any other items from version_for_Hop2 , the table turns out blank.

      Expected Result is- 

      When I select V1 From version_for_Hop1 and V4 from version_for_Hop2, it should show respective data in each columns.