Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

How to filter data based on two columns

Hi,   I am new to power bi platform, can someone help me.   I want to filter my table/data in my visuals based two columns.  for example i have a table with columns as transaction, period,...
Need Help
Show and Tell
  • ryan_mayu's avatar
    ryan_mayu
    5 years ago

    Anonymous 

    here is a workaround.

    Column = IF(CALCULATE(DISTINCTCOUNT('Table (2)'[NATURE]),ALLEXCEPT('Table (2)','Table (2)'[period]))=1,"no","Yes")

    then add a filter and select Yes

ChaitanyaTagare's avatar
ChaitanyaTagare
Microsoft Employee
5 years ago

You can create two slicers on top of the table.

1.Drag slicers controll from visualization section.

2. Slicer1- Period  (drag period field into this slicer)

3. Slicer2- Nature (drag Nature field into this slicer)

When you select P1 period from slicer1 it will show nature A and B

and for P2 it should show values for nature B only.

 

With slicer2 you will able to select Nature A or B and corrosponding period.

Let me know if this helps.