User Profile
FLHound
Frequent Visitor
Joined 4 years ago
User Widgets
Contributions
Measure or column that returns 5 year average for month - using different year ranges
I'm sorry about the confusing title - hard to keep it to a one-liner! What I'm looking to do is get the the average of the top 5 years for each month, excluding the max year for that month. For example, the max year for September - December is 2023, so I want the average of the top 5 years EXCLUDING 2023 (2018-2022). The max year for January - May is 2024, so I want the average of 2019-2023. I want to use these values in a combo column/line graph that already has a filter of filters applied to it through the filter pane, so it needs to ignore those.Bubble size scale with Azure Map
Hi everyone, I've created a map where every bubble is representative of a rain station, and the bubble size is the sum of inches of rainfall. What I'm wanting is the bubble size to keep the same, absolute scale when filtering (like by month, for example). As it is currently, the map is pretty useless when filtering to compare different months. A bubble of the same size will represent 3.08 inches of rainfall in January, and 19.90 inches in April. In my screenshot below, the same bubble in April was much smaller than the one in January, even though April had over 3x more rain. I realize the "Size" category literally says it is for relative sizing, but it is possible to override this somehow? The bubble layer scaling method is currently set to linear...it doesn't seem as if the other options will fix my problem. Do I need to write a measure for "Size" field instead just dropping my "inches rainfall" column? Thank you,Reorder Matrix Columns and sort by new "leading" column header
Hi everyone, I have a matrix with multiple value columns, broken into 2 major column headers: "2021" & "2022". Since my column headers are integers, the matrix puts them in ascending order (2021, then 2022). This is my first problem. I need 2022 to be the first, or leftmost header, then followed by 2021. I did create a reference table for this custom sorting where I achieved what I wanted, but another issue arises: Even when I use my custom sorted column header, the "sort-by" on the visual (accessed by the ellipses on the top left) is using 2021 as the driver, not 2022. I want to sort the entire matrix by a values under the 2022 header. Any help is much appreciated!Re: Return Max of Sums and corresponding label?
Greg_Deckler Hi, sorry for not being clear enough My sample data is below I'm hoping to return the max value per month and the year in which that value corresponds to, so "10.9" & "2016" for January, "11.6" & "2020" for July, etc. Month January February March April May June July August September October November December 2016 10.9 3.5 1.9 0.4 5.8 3.7 4.7 10.8 7.6 5.0 0.0 0.6 2017 1.8 0.8 0.6 1.8 5.2 17.4 9.2 6.8 16.8 8.6 1.1 1.7 2018 1.1 0.3 0.5 4.2 12.0 8.5 8.1 6.3 5.3 1.5 1.6 1.1 2019 6.1 1.3 1.8 1.6 7.0 7.6 8.9 10.7 1.6 5.5 1.5 2.8 2020 1.2 2.3 0.4 3.7 6.3 8.7 11.6 7.3 8.6 8.0 6.7 3.1 2021 0.3 1.3 0.9 3.2 1.0 10.2 6.1 4.6 8.1 4.1 3.0 1.2 2022 1.4 0.9 1.4 2.7 6.5 11.0 4.6Return Max of Sums and corresponding label?
Hi everyone, I'm trying to recreate the following in Power BI - and while I've gotten close - I can't figure out how to pull the month names I want as well. What I want: to return the "record" (max) rainfall per month and the year which that record corresponds to.
