Forum Discussion

LS69's avatar
LS69
Frequent Visitor
3 years ago

Filter a slicer

Hello im still new i Power Bi. I have a issue regarding showing or hide(outgray) values in a slicer. 

 

scenario:

 

I have two slicer where i from table 1 get 

Department AOffice A1,A2
Department BOffice B1,B2
Department COffice C1;C2

this works fine.

 

In the other related table(also a slicer) i get values  

LOffice 1,2,3,4,5,6,,,,

 

What i want to achieve is in the when i choose for example Dep A and Office A1, only get for instance LOffice1 which is related to Dep A and Office A1.  

 

Right now i get all the values(1,2,3,4,5,6,) from LOffice unregarding if it is related or not. Is there a quick solution to solve this issue.

 

All i want is to show only related values in LOffice-slicer and it's ok if the other values are hidden or outgrayed or something. 

 

In Power Pivot there working just fine on the same model.

 

Regard L

Need Help

1 Reply

  • amitchandak's avatar
    amitchandak
    Super User
    3 years ago

    LS69 , Second table needs unpivot based on what I got, and a new column post that.

     

    Power Query Table.Unpivot, Table.UnpivotOtherColumns: https://youtu.be/0FEGEAz9UMw

     

     

    The information you have provided is not making the problem clear to me. Can you please explain with an example.

    Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
    Appreciate your Kudos.