User Profile
satkin
Advocate I
Joined 3 years ago
User Widgets
Contributions
Field Parameter Slicer change legend and a second slicer?
I've a field parameter, four different categories selectable from it, CLB, CS, RB, BM in Slicer1 I've got this field parameter also set as the legend of my visual, so when I choose RB it shows the legend (L, M, H), choose BM it's (P, R, I or T). Some categories chosen in the field parameter can have big discrepancies in categories, so when plotted on a line chart the smaller categories appear flat due to the range of total values shown. Is it possible to set up a second slicer (Slicer2) that dynamically, based upon the selection in Slicer1 will show the values of the selected field parameter, e.g. Slicer1 = RB, Slicer2 shows L, M, H, so that I can then filter the visual to view everything or filter out outliers/large categories to see the detail of those flatter lines? ThanksSolved726Views0likes4CommentsStandard Deviation as a column either in Power Query or DAX
Hi, Below is a screen shot of a standard deviation calculation per variable for the prior 6 months observations. Column E shows the Excel formula used in column D. My raw data is columns A-C, and I need to replicate the creation of column D in Power BI, either through Power Query or DAX. I've made numerous attempts, but am clearly missing something as I just don't seem able to do it. Is this possible? If so any guidance on how would be appreciated. Many thanksSolved851Views0likes2CommentsMatrix - Only show quarters for specific years
Hi, I've got a matrix with a date hierarchy in my columns, with measures switched to rows, giving me something like this... 2020 2021 2022 2023 Total Customers 57,168 67,349 68,621 59,448 Total Value 6,562,063 5,929,856 6,140,753 4,212,423 I've been asked by my client if they can see the latest year split in to quarters, but still retain the historic years at just an annual view. Using the hierarchy, its easy to see each year by quarter, but trying various ways, I don't seem able to just view 2023 in quarters. Is this possible? 2020 2021 2022 Q1-23 Q2-23 Q3-23 Q4-23 Total Customers 57,168 67,349 68,621 13,173 13,346 25,743 7,186 Total Value 6,562,063 5,929,856 6,140,753 1,935,900 865,521 1,009,112 401,890 Any guidance would be appreciated. Thanks.Solved1.2KViews0likes2CommentsFilter dates using two slicers (From / To)
Hi, I'm wanting to have two slicer on my page, Quarter From and Quarter To. I've set these up as independnet slicers by creating two tables, Quarter From and Quarter To that are created using the SUMMARIZE function reading from my date table. This means I can make independnet selections in the two slicers. I don't know how to the apply these selections to the actual date table though, so that my selected range is all that is reported on. Currenly my visuals continue to show all Quarters in the dates table, rather than just those in the selected range. I know this would be easy with a single slicer to choose a date range, but unfortunately I need to have the two options as slicers. Date Table Date Quarter 01/10/2022 2022Q4 ... 2022Q4 31/12/2023 2022Q4 01/01/2023 2023Q1 ... 2023Q1 31/03/2023 2023Q1 01/04/2023 2023Q2 ... 2023Q2 31/05/2023 2023Q2 Quarters From / Quarters To 2022Q4 2023Q1 2023Q2 Measures Selected From = CALCULATE( MIN(Dates[Date]), Dates[Quarter] = 'Quarter From'[Quarter] ) Selected To = CALCULATE( MAX(Dates[Date]), Dates[Quarter] = 'Quarter To'[Quarter] ) If I select 2023Q1 in my From slicer and 2023Q2 in my To slicer, any visual will show all 3 quarters in it when I use Quarter from the Dates table in the visual. Can I get it to be dynamic to the selected quarterly values? Many thanksSolved556Views0likes2CommentsFilter one table by less than value of another table or list value
Hi, I've got two tables coming from different sources. One has quarterly data, (QtrTable) repeated per month of the quarter for many years. As it repeats for the quarter, it can have future months, e.g. May/June 2023 are future at the moment, but they're in this source. I then have a secondary source which contains monthly data (CoreTable), not going as far back as the other file, but stopping at the latest month (Apr23). I want to take the maximum date in the CoreTable and apply this as a filter on the date column of the QtrTable, so that both tables only contain data upto Apr23. From browsing around, I thought I'd found how by creating a list, which just contains Apr23 from CoreTable and then tried filtering the QtrTable date on this value, but it didn't work. I'm a bit stumped on how to progress. The two tables are huge, so merging them isn't realy feasible and unfortunately I'm stuck with having these two sources. Any guidance would be appreciated. Thanks.Solved1.8KViews0likes2CommentsPrior months category in current month
I've been asked to produce some reporting that I'm having trouble with. I've got some data, Account ID Reporting Month Balance Risk Band 1 01/07/22 1000 5 1 01/08/22 2000 4 1 01/09/22 3000 4 1 01/10/22 4000 4 1 01/11/22 5000 3 1 01/12/22 6000 2 1 01/01/23 7000 2 2 01/07/22 7000 Z 2 01/08/22 6000 Z 2 01/09/22 5000 5 2 01/10/22 4000 4 2 01/11/22 3000 4 2 01/12/22 2000 3 2 01/01/23 1000 4 What I'm wanting to do is, based on a slicer selection of x months ago, show the current month and its corresponding balance, but with the risk band from the point in time selected. E.g. Current month selected: 2 3 4 5 Z 01/07/22 1000 7000 01/08/22 2000 6000 01/09/22 3000 5000 01/10/22 8000 01/11/22 5000 3000 01/12/22 6000 2000 01/01/23 7000 1000 1 month ago selected: 2 3 4 5 Z 01/08/22 2000 6000 01/09/22 3000 5000 01/10/22 4000 4000 01/11/22 8000 01/12/22 6000 2000 01/01/23 7000 1000 6 months ago selected: 2 3 4 5 Z 01/01/23 7000 1000 I can see how I could do this by having 3 columns (Current Risk Band, 1 Month Ago Risk Band, 6 Months Ago Risk Band), but I need to repeat this for different variables, not just Risk Band, I'd end up with an additional 60+ columns if I did this, so keen to see if it can be done dynamically. Is this possible, and if so, how would I go about it? Any guidance would be really appreciated. Thank youSolved610Views0likes1Comment
Data Privacy
Microsoft Fabric Community and Privacy
To learn more about how we manage your data, please review the Microsoft Fabric Community Data Privacy guide.