cancel
Showing results for
Did you mean:
Frequent Visitor

Create Slicer based off of Already Sliced Values for Unique Count (Min/Max)

Hi there,

I'm stumped...

I have 5 slicers that are slicing by (Location, Year Month, Day Date, Order Method and Service Method)

I then have a bunch of visuals that are based off of those slicers

I have a map created that goes by lat/long and is based off of the unique counts of latitude to look at how many times that location ordered something based off of the slicer criteria (By location, dates, methods and ect)

Problem now is, that I would like to slice between the (min of that count - max of that count) - case below would be between 1-7...kicker is that those counts change whenenever you use the 5 slicers that i spoke of above

I tried inserting another slicer and I can't make it based off of the values that the 5 slicers found as a min-max count

I feel like i have to write something in dax or create a new table to find the variable min/max...ugh i'm stumped...any help would be appreciated!

 LatitudeNumber LongitudeNumber Count of OrderNumber 25.938001 -80.212676 7 25.979125 -80.2194305 6 25.9678244 -80.1952612 5 25.9473582 -80.224267 4 25.960768 -80.194917 4 25.9619327 -80.1890946 4 25.9385065 -80.2083619 3 25.9449906 -80.2109331 3 25.9532451 -80.2062483 3 25.9543107 -80.1815611 3 25.9482849 -80.2082748 1 25.9487656 -80.2048738 1 25.9487667 -80.2008757 1 25.9489163 -80.2169031 1 25.9497012 -80.1917783 1 25.9500862 -80.1854603 1
2 ACCEPTED SOLUTIONS

Accepted Solutions
Microsoft

Re: Create Slicer based off of Already Sliced Values for Unique Count (Min/Max)

Hi @broman5000,

That's because the values from a measure which needs context. There could be two solutions.

1. Add a new column like below. Since it becomes a column, you can add it in a slicer easily. There could be many duplicates.

```column =
CALCULATE (
COUNTROWS ( 'table' ),
ALLEXCEPT ( 'table', 'table'[LatitudeNumber], 'table'[LongitudeNumber] )
)
```

2. Create a measure and add it in the Visual Level Filter.

Best Regards,

Dale

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

Re: Create Slicer based off of Already Sliced Values for Unique Count (Min/Max)

Hi @broman5000,

Could you please tell me if you get the answer or the solution?

Best Regards,

Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 REPLIES 3
Frequent Visitor

Slice by changing count number based off other slicers

Hi there,

I'm stumped...

I have 5 slicers that are slicing by (Location, Year Month, Day Date, Order Method and Service Method)

I then have a bunch of visuals that are based off of those slicers

I have a map created that goes by lat/long and is based off of the unique counts of latitude to look at how many times that location ordered something based off of the slicer criteria (By location, dates, methods and ect)

Problem now is, that I would like to slice between the (min of that count - max of that count) - case below would be between 1-7...kicker is that those counts change whenenever you use the 5 slicers that i spoke of above

I tried inserting another slicer and I can't make it based off of the values that the 5 slicers found as a min-max count

I feel like i have to write something in dax or create a new table to find the variable min/max...ugh i'm stumped...any help would be appreciated!

 LatitudeNumber LongitudeNumber Count of OrderNumber 25.938001 -80.212676 7 25.979125 -80.2194305 6 25.9678244 -80.1952612 5 25.9473582 -80.224267 4 25.960768 -80.194917 4 25.9619327 -80.1890946 4 25.9385065 -80.2083619 3 25.9449906 -80.2109331 3 25.9532451 -80.2062483 3 25.9543107 -80.1815611 3 25.9482849 -80.2082748 1 25.9487656 -80.2048738 1 25.9487667 -80.2008757 1 25.9489163 -80.2169031 1 25.9497012 -80.1917783 1 25.9500862 -80.1854603 1
Microsoft

Re: Create Slicer based off of Already Sliced Values for Unique Count (Min/Max)

Hi @broman5000,

That's because the values from a measure which needs context. There could be two solutions.

1. Add a new column like below. Since it becomes a column, you can add it in a slicer easily. There could be many duplicates.

```column =
CALCULATE (
COUNTROWS ( 'table' ),
ALLEXCEPT ( 'table', 'table'[LatitudeNumber], 'table'[LongitudeNumber] )
)
```

2. Create a measure and add it in the Visual Level Filter.

Best Regards,

Dale

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

Re: Create Slicer based off of Already Sliced Values for Unique Count (Min/Max)

Hi @broman5000,

Could you please tell me if you get the answer or the solution?

Best Regards,

Dale

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

Announcements

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

Power BI Desktop Update - February 2020

We are super excited for our update this month, as we are releasing two of our top community requests!