Forum Discussion

LéaGr's avatar
LéaGr
Helper I
6 years ago
Solved

Including groups in normal slicer

Hi everybody,   I am asking for help on an issue I can't solve by myself (been trying for two days...) :') I am trying to display groups in a slicer without using the Hierarchical slicer.    I h...
Need Help
Show and Tell
  • mwegener's avatar
    mwegener
    6 years ago

    Hi LéaGr,

     

    you can try a many-to-many relationship

    https://docs.microsoft.com/en-us/power-bi/desktop-many-to-many-relationships

                        n:1                                   n:m

    Fact-Table <--- Country Dim-Table <--- > Country Filter-Table

     

    Your filter table could look like this

    Country ;Filter ;SortID
    Portugal ;Portugal ;6
    Portugal ;Southern Europe ;3
    Portugal ;International ;2
    Italy ;Italy ;7
    Italy ;Southern Europe ;3
    Italy ;International ;2
    Germany ;Germany ;4
    Germany ;International ;2
    France ;France ;5
    France ;National ;1

     

mwegener's avatar
mwegener
Most Valuable Professional
6 years ago

Hi LéaGr,

 

you can try a many-to-many relationship

https://docs.microsoft.com/en-us/power-bi/desktop-many-to-many-relationships

                    n:1                                   n:m

Fact-Table <--- Country Dim-Table <--- > Country Filter-Table

 

Your filter table could look like this

Country ;Filter ;SortID
Portugal ;Portugal ;6
Portugal ;Southern Europe ;3
Portugal ;International ;2
Italy ;Italy ;7
Italy ;Southern Europe ;3
Italy ;International ;2
Germany ;Germany ;4
Germany ;International ;2
France ;France ;5
France ;National ;1

 

  • LéaGr's avatar
    LéaGr
    Helper I
    6 years ago

    mwegener ,

     

    Thanks a lot for your help that worked perfectly. I created a new Filter Table as in your example and liked it to my Contry table.

     

    Have a good day,

     

    Léa