PowerBI Create Relation and Add Alert to the Matrix
The bases have already been introduced, everything is calculated and the formulas have been created.Bases do not need to be cleaned.At the moment, the problem is that several people worked with PowerBI and each introduced its own adjustments, it is necessary to upgrade the table and connect it to all the filters, i.e.Establish the right relationships.The table in Excel is as follows:
The second part:
You need to integrate/create the table data in PowerBI and add the ALERT system.The Alert system should show all the GlobalCode that have the status of "Red" for that week (this week will always be the first column).Since some codes have a cross status several weeks in a row I would like to enter the 3rd step system ALERT If the status of red is available only on the first week, then we assign it Alert 1, if 2 weeks in a row, then the status Alert 2 and if 3 weeks in a row, then the status Alert 3.The Alert system is only required to instantly see the most problematic GlobalCode through the filter.that is.There must be a filter that will only show the data codes.For the present time as an example (Problem 1 appendix).Below there is a matrix in the color range, to it or in it and you need to add Alert.A common problem with the tables: now a new database has been added to the tasks and the problem with it is that it is not yet out to connect the multi-filter.If you select a value in one table, it will filter what is required, but if you select a value in another table, the filter will cease to work in another direction.This problem needs to be corrected.There may be a solution to reduce the matrix size as well.It’s hard to see only the list of GlobalCode and see the colors of the weeks where there are problems.
Applications 1
Current freelance projects in the category Databases & SQL
Technical task: Dashboard on Dune AnalyticsStyle reference: dune.com/filarm/polymarket-activity Task Create a beautiful dashboard on Dune for our bot for Polymarket. There are no real data — everything is generated synthetically, but it looks logical and plausible. Main requirement The dashboard must work… Databases & SQL, Cryptocurrency & Blockchain ∙ 15 minutes back ∙ 1 proposal |
Work with BAS CORPHello! Currently, the following tasks need to be completed: Adjustment of the printed form in BAS KORP according to the client's parameters. Specifically, the task is not to display certain fields. Updating the classifier of professions in BAS KORP for a number of… Payment Systems Integration, Databases & SQL ∙ 12 hours 4 minutes back ∙ 7 proposals |
Need a 1C specialist for refinements and development.I am looking for a 1C specialist for freelance collaboration. I am currently working with a contractor who provides support and maintenance for the 1C system. However, due to the contractor's workload, there is a need for prompt execution of additional tasks, improvements, and… Databases & SQL ∙ 1 day 18 hours back ∙ 11 proposals |
Restoring Instagram after a banOn March 3, 2026, my Instagram was blocked due to a violation of rules. I believe there has been some mistake, as the page was personal with photos and videos of my personal trips. I did not post any comments anywhere. I have sent several appeals. I cannot download my files… Databases & SQL, Web Programming ∙ 2 days 5 hours back ∙ 4 proposals |
Eliminate the issue of incomplete data import from Excel files of Nova Poshta specifications into 1C:
45 USD
Goal: There is a processing in 1C for uploading the specifications of Nova Poshta. For unclear reasons, it has stopped loading some tabular data. We need to find the reason and eliminate the problem of incomplete data import from Excel files of Nova Poshta specifications into… System & Network Administration, Databases & SQL ∙ 5 days 12 hours back ∙ 16 proposals |