cancel
Showing results for
Did you mean:
Highlighted
Frequent Visitor

## conditional slicer and table dashboard

Hello,

I have the following 2 tables and I created a Slicer with the right table:

In this filter,

• P1 are those incidents where Priority = 1
• P1-P2 are those incidents where Priority = 1 or Priority = 2
• P1-P3 are those incidents where Priority  = 1, or Priority = 2, Or Priority =3
• P1-P4 are all incidents (no filtering)

I need to create Table dashboard in where, if Filter=P1, only shows incidents with Priority = 1, but if filter = P1-P2 the table shows all incidents P1 or P2...

Could you give me a clue ? Thanks in advance.

Kind regards,

Jorge.

1 ACCEPTED SOLUTION

Accepted Solutions
Super Contributor

## Re: conditional slicer and table dashboard

Hi @jgo1986

You may create a measure like below and use it in visual level filter and set it =1.

```Measure =
IF (
SELECTEDVALUE ( 'Filter'[Order] ) = 1
&& MAX ( Incidents[Priority] ) = 1,
1,
IF (
SELECTEDVALUE ( 'Filter'[Order] ) = 2
&& MAX ( Incidents[Priority] ) <= 2,
1,
IF (
SELECTEDVALUE ( 'Filter'[Order] ) = 3
&& MAX ( Incidents[Priority] ) <= 3,
1,
IF (
SELECTEDVALUE ( 'Filter'[Order] ) = 4
&& MAX ( Incidents[Priority] ) <= 4,
1
)
)
)
)
```

Regards,

Community Support Team _ Cherie Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 REPLIES 2
Super User

## Re: conditional slicer and table dashboard

It looks like somebody was trying to accomplish something similar here: https://community.powerbi.com/t5/Desktop/Is-there-any-way-to-get-a-slicer-where-applied-value-is-les...

Super Contributor

## Re: conditional slicer and table dashboard

Hi @jgo1986

You may create a measure like below and use it in visual level filter and set it =1.

```Measure =
IF (
SELECTEDVALUE ( 'Filter'[Order] ) = 1
&& MAX ( Incidents[Priority] ) = 1,
1,
IF (
SELECTEDVALUE ( 'Filter'[Order] ) = 2
&& MAX ( Incidents[Priority] ) <= 2,
1,
IF (
SELECTEDVALUE ( 'Filter'[Order] ) = 3
&& MAX ( Incidents[Priority] ) <= 3,
1,
IF (
SELECTEDVALUE ( 'Filter'[Order] ) = 4
&& MAX ( Incidents[Priority] ) <= 4,
1
)
)
)
)
```

Regards,

Community Support Team _ Cherie Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Announcements

#### Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

#### Power Platform Summit North America

Register by September 5 to save \$200

#### PBI Community Highlights

Check out what's new in the Power BI Community!

#### Watch Sessions On Demand!

Continue your learning in our online communities.

Top Kudoed Authors
Users Online
Currently online: 41 members 1,399 guests
Recent signins: