Filtering between week end dates with two dropdown (start period and end period)
Hello community, I am facing the following problem. I want to be able to filter between two week end dates. I need to use two dropdown filter for a start and en period. Each drop down will only have the week end date (suppose every friday date). Currently PowerBI offers the possibility to filter between dates but with a slider ( which is a calnder with all dates displayed, not what I am lokking for). I found this post that tackle the issues : https://community.fabric.microsoft.com/t5/Desktop/Drop-down-box-to-filter-two-dates/m-p/1996708 However this solution does seems really efficient if I were to add a filter to each of my visualisations ? Do you have any ideas how this could be done more efficiently ? Let me know you thoughts or input about this 🤔
TopN + Others Pie Chart filtered by Date (Quarter and Year)
Hello fellow PowerBI enthusiasts, I have a question that I'm hoping someone could help me with. I have a table containing city codes (id_kota), credit categories (jenis_kredit), dates, and nominal values. The nominal values represent the amount of credit for each city, credit category, and date. Now, I'm trying to create a pie chart that can be filtered by date, specifically by quarter and year. The city codes consist of 39 different codes, which makes it quite challenging if I want to display all of them on the pie chart. Therefore, what I want to achieve is to show only the Top 5 city codes for each date based on the nominal values. For the remaining city codes, I'd like to group them as "Others." Additionally, it's important to have the ability to filter the chart based on the date. The pie chart example (I made it on Excel): I've watched several tutorials on YouTube and looked through the Power BI community, but the solutions I found don't quite fit my specific problem. Any assistance would be greatly appreciated. Thank you in advance!
how to get the previous nonblank value
i have posted this question twice before but the provided answer did not solve the case. im trying to find the previous day closing price for stocks so that i can calulate day on day change. the problem is stock market is not open everyday and in the days when the market is closed previous day price will be blank. im using the following measure but it's not returning the intended output when i present it in card visual or in scroller custom visual previous day price1 = CALCULATE(SUM('stocks data'[Close]), OFFSET(-1,ALLSELECTED('stocks data'[Date]),ORDERBY('stocks data'[Date],ASC))) as in the image, the measure works in table visual format but doesnt give last date nonblank value in the card visual. the expected output in the card visual should be 142.16 instead of 131062.04 appreciate the support as this is an urgent matter.
Date visual filter missing after upgrade
Hi We recently upgraded our Power BI Report Server from January 2019 (we also briefly had a test server for January 2022) to September 2022. The date visual filter is now gone on my graph. I used to get: Now I get (note no Date visual filter): How can I get the visual filter back?
