Global Text Search and Filter Across All Tables in Power BI
Greetings, Currently, couldn't find a method to enable users to search through every column in every table for a particular text string and promptly filter visuals on the page with corresponding results (Acting like a Search Bar). While workarounds like concatenating columns exist, they're inefficient and impractical for large datasets. Any enhancement facilitating this capability would greatly enhance efficiency and empower users to efficiently delve into their data. Thank you.
Unable to attach the jason file in shapemap charts
I have tried many with different jason file to upload in Shapemap charts to get delhi region charts.But unable to upload the delhi region chart. I am attaching the problem and file format as well please give me solution so that i can complete my project on time.
Dynamic Inventory Reconciliation: Aligning Opening and Closing Balances in Power BI
I have created an Inventory Reconciliation report that includes a Year slicer. The report's main visual is a matrix with the following rows: Opening Inventory Purchases Sales Closing Inventory (Calculated) On-Hand Quantity The Closing Inventory (Calculated) is determined using this formula: Closing Inventory (Calculated) = Opening Inventory + Purchases - Sales The matrix has Months set on the Columns. For example, if the year 2023 is selected: January’s Opening Inventory is calculated using the following DAX formula: Opening Inventory (Q) = CALCULATE( [On-Hand Qty], PREVIOUSMONTH('Calendar (On-Hand)'[Dates]) ) For February, the Opening Inventory should use January’s Closing Inventory (Calculated) or the previous month's Closing Inventory. Currently, the Opening Inventory row uses its formula to calculate results, which might lead to inconsistencies. I believe the Opening Inventory should instead depend on the Closing Inventory (Calculated) from the previous month. What would be your solution?
Custom Sorting in PowerBI?
Hello all, Seeing as how helpful people were with my last two questions, I thought I'd ask another, which has been nagging me. I'm aware of the sorting function in graphs, but that seems to sort the items alphabetically. What I'm hoping to do is sort non-alphabetically, in an order that makes sense otherwise - highest to lowest, or whatever the case. See here: I'd like it to read Critical, High, Medium, Low. Is there anything I can do here? Thank you!
DAX formula
Dear all, I'm looking for a DAX formula. I have the following data: From this I want to create a trending graph, so showing 2023ACT and 2024BUD in the same graph, monthly figures. I would like to have the data of the green items to be displayed in my graph. So for the 2023ACT the category C2 should be taken. But not when the scenario is 2024BUD. As in 2024BUD I want to have the selection of the scenario's MEN_C2, MEN_C2_ALLOC2 and MEN_C2_CANCEL2. In the scenario 2024BUD he can't take at all the C2 category, as this is not with monthly figures but only December. Somebody who can help me with the correct DAX please? Thanks a lot Kind regards Cindy
Filter Pie Chart by Value Slicer
Hi, I want to merge these 2 pie charts into 1 pie chart. I want to only have 1 pie chart with a slicer for: "Country" and "City". The Details: Date/Year are the same for both pie charts. That means when I click on the "Country" slicer, it will show the left pie chart, count distinct of the number of countries visited in a year, and when I click the "City" slicer, it will show the right pie chart, count distinct of the number of cities visited in a year. Thank you.
