cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
broman5000 Frequent Visitor
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!

 

LatitudeNumberLongitudeNumberCount of OrderNumber
25.938001-80.2126767
25.979125-80.21943056
25.9678244-80.19526125
25.9473582-80.2242674
25.960768-80.1949174
25.9619327-80.18909464
25.9385065-80.20836193
25.9449906-80.21093313
25.9532451-80.20624833
25.9543107-80.18156113
25.9482849-80.20827481
25.9487656-80.20487381
25.9487667-80.20087571
25.9489163-80.21690311
25.9497012-80.19177831
25.9500862-80.18546031
2 ACCEPTED SOLUTIONS

Accepted Solutions
Microsoft v-jiascu-msft
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.

View solution in original post

Microsoft v-jiascu-msft
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.

View solution in original post

3 REPLIES 3
broman5000 Frequent Visitor
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!

 

LatitudeNumberLongitudeNumberCount of OrderNumber
25.938001-80.2126767
25.979125-80.21943056
25.9678244-80.19526125
25.9473582-80.2242674
25.960768-80.1949174
25.9619327-80.18909464
25.9385065-80.20836193
25.9449906-80.21093313
25.9532451-80.20624833
25.9543107-80.18156113
25.9482849-80.20827481
25.9487656-80.20487381
25.9487667-80.20087571
25.9489163-80.21690311
25.9497012-80.19177831
25.9500862-80.18546031
Microsoft v-jiascu-msft
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.

View solution in original post

Microsoft v-jiascu-msft
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.

View solution in original post

Helpful resources

Announcements
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

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?

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

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!

Power Platform Online Conference

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

Top Solution Authors