Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 |
Solved! Go to Solution.
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
Hi @broman5000,
Could you please tell me if you get the answer or the solution?
Best Regards,
Dale
Hi @broman5000,
Could you please tell me if you get the answer or the solution?
Best Regards,
Dale
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
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 |
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
100 | |
80 | |
64 | |
57 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |