Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

different filters on same 2 visuals on same page?

I wanted to display the same 2 visuals; but one shall have more restricted content…

 

My dataset consists of:

 

Fact

Project

345

1

3451

2

591

3

100000

4

 

 

Dimension

Project

Role

User Number

Team

1

Boss

55

C

1

Lead

11

C

1

Work

43

C

2

Boss

99

C

2

Lead

1034

D

2

Work

9

C

3

Boss

5

C

3

Lead

419

C

3

Work

4

A

4

Boss

2

A

4

Lead

5184

P

4

Work

14519

A

 

 

I will add 2 filters in my page: User Number and Role.

 

If a user for example selects     User: 5, role: Boss.

 

One visual should display only that; and the other visual should display, all Bosses from Team C (this is user’s 5 team). That is:

Project

Role

User Number

Team

1

Boss

55

C

1

Lead

11

C

1

Work

43

C

2

Boss

99

C

2

Lead

1034

D

2

Work

9

C

3

Boss

5

C

3

Lead

419

C

3

Work

4

A

4

Boss

2

A

4

Lead

5184

P

4

Work

14519

A

 

I want to achieve this by giving the user just 2 filters: User Number and Role.

 

Need Help

1 Reply

  • MohammadLoran25's avatar
    MohammadLoran25
    Icon for Solution Sage rankSolution Sage
    3 years ago

    Hi Anonymous,

    Please follow these steps:

     

    1-Duplicate your "Dimension" table and name it "SecondDimension" as your new table.

     

    2-Then Create a flag measure as below:

     

    SELECTEDTEAMFLAG =
    VAR _SELECTEDTEAM =
        SELECTEDVALUE ( Dimension[Team] )
    RETURN
        SUMX (
            FILTER ( SecondDimension, SecondDimension[Team] = _SELECTEDTEAM ),
            1
        )

     

    3-Then add your second visual fields from the "SecondDimension" table.

     

    4-Put the measure [SELECTEDTEAMFLAG] as a filter on the visual you just made in step 3 and set the condition of is 1 for it. You also need to set the condition for role as "Boss" on it which is shown in the attached image.

     

    If it solves your problem, then please consider Accepting it as the solution
    Regards,

    Loran