dashboard

4 Topics

Compare values from 2 visualized tables in powerbi dashboard (NOT BACK END TABLES COMPARISON)
Hi there, I have a challenge for the expert powerbi community!! Within my company we are currently looking to compare two table values in the powerbi dashboard (FRONTEND) to return an marker wheter the individual green value (which is filtered by "studiegroep", "periode" & "voornaam") meets the groupbenchmark pink value (filtered by :"benchmarkyear" but with changing data based on a backend division of data). Using PowerQuery within the tables is not possible given the pink data is changing when using diffent filters (so the pink data is not directly from another back-end table but is only generated in the dashboard by using measures & filters in the dashboard. Normally in excell you would simply make a calculation based on the respective cells (see example below) and add a conditional formatting, see example in excell. However, I am looking for a similar solution within the powerbi dashboard. Is this possible in PowerBi? would love to hear from anyone who can offer help!
DMSJennifer
4 years ago Place DAX Commands and Tips
1.3KViews
0likes
2Comments
Using SWITCH to put candidates into categories, however ...
... individual instances will usually belong to multiple categories. Question Is there a way to have a singular column/measure which permits candidates to simultaneously be in multiple defined categories at once, based on their stage progression? Context I am building a dashboard for our recuitment team based off of extract from Workday Recruiting. There are six applicant/candidate stages we monitor: 1. Review 2. Screen 3. Interview 4. Reference Check 5. Offer 6. Ready for Hire I am looking to report on the "Candidate Progression Funnel" to monitor progression at each of these six steps. This means that each candidate should count towards not only for their current stage (e.g. Interview) but also the preceding stages they've come through (Review & Screen). An individual who makes it to an Interview also needs to be in the counts for Review and Screen. Someone who only makes it to Review only counts towards Review while someone who makes it to Offer stage counts for stages 1-5, but not Ready for Hire yet. I already have created six individual calculated columns for each for the Progression Stages: Candidate Progress 03: Interview = IF( (EXTRACT_02[Candidate Stage]="Interview") || (EXTRACT_02[Candidate Stage]="Reference Check") || (EXTRACT_02[Candidate Stage]="Offer") || (EXTRACT_02[Candidate Stage]="Ready for Hire") || (EXTRACT_02[Last Recruiting Stage]="Interview") || (EXTRACT_02[Last Recruiting Stage]="Reference Check") || (EXTRACT_02[Last Recruiting Stage]="Offer") || (EXTRACT_02[Last Recruiting Stage]="Ready for Hire") ||, ("Interview"), ("No") ) The issue is now that I have six different calculated columns rather than a singular one for the purposes of visualization. I'm in need of a single column which has all six progession stages in the same place. I've attempted to use SWITCH to no avail, yet: Candidate Progress: All 01 = SWITCH( TRUE(), EXTRACT_02[Last Recruiting Stage]="Review" || EXTRACT_02[Last Recruiting Stage]="Screen" || EXTRACT_02[Last Recruiting Stage]="Interview" || EXTRACT_02[Last Recruiting Stage]="Reference Check" || EXTRACT_02[Last Recruiting Stage]="Offer" || EXTRACT_02[Last Recruiting Stage]="Ready for Hire", "Review", EXTRACT_02[Last Recruiting Stage]="Screen" || EXTRACT_02[Last Recruiting Stage]="Interview" || EXTRACT_02[Last Recruiting Stage]="Reference Check" || EXTRACT_02[Last Recruiting Stage]="Offer" || EXTRACT_02[Last Recruiting Stage]="Ready for Hire", "Screen", EXTRACT_02[Last Recruiting Stage]="Interview" || EXTRACT_02[Last Recruiting Stage]="Reference Check" || EXTRACT_02[Last Recruiting Stage]="Offer" || EXTRACT_02[Last Recruiting Stage]="Ready for Hire", "Interview", EXTRACT_02[Last Recruiting Stage]="Reference Check" || EXTRACT_02[Last Recruiting Stage]="Offer" || EXTRACT_02[Last Recruiting Stage]="Ready for Hire", "Reference Check", EXTRACT_02[Last Recruiting Stage]="Offer" || EXTRACT_02[Last Recruiting Stage]="Ready for Hire", "Offer", EXTRACT_02[Last Recruiting Stage]="Ready for Hire", "Ready for Hire", "NA" ) I believe this is happening b/c "Review" encompasses all applicants (rightfully so) based on the logic and thus applicants aren't counting towards multiple stage categories. How might I have a singular column/measure which permits candidates to simultaneously be in multiple defined categories at once based on their stage progression?
Solved
Anonymous
5 years ago Place DAX Commands and Tips
2.3KViews
0likes
9Comments
Convert Earlier function in DAX to Power Query (Reverse Cumulative)
Hello, Apologies in advance but I cannot seem to find a solution to this question. Basically, I wrote a DAX query that works perfectly, but i realised a Power query will be better because I need Power's pivot functionality for some required post analysis. I just started learning DAX and have no idea how to write power queries. For the query, I created two variables _department & _project and execute the following: CALCULATE(COUNTROWS('Table'),FILTER('Table',__department='Table'[department]),FILTER('Table',__project='Table'[Project type]),FILTER('Table','Table'[date]>=EARLIER('Table'[date])) The query filters the table by department and project, then does a reverse cummulative count on the filtered results, grouped by dates. Any idea would be a good starting point for me. Thanks
Solved
Anonymous
5 years ago Place DAX Commands and Tips
1.9KViews
0likes
4Comments
How to calculate a running total of Vulnerabilities?
Hello, For the life of me I cannot figure out how to create a running total trend line of vulnerabilities from my organizations Fortify SAST tool. Below is an example of the data that I am currently exporting into Excel. What I am trying to do is show a running total of vulnerabilities by Severity at an enterprise level for all applications, and then at an individual application level. I would also create trend lines for OWASP status, Developer Status, etc. Example Data Vuln ID Severity Status Developer Status Introduced Date OWASP ApplicationID ReleaseID Category 1 Critical Fix Validated Will Not Fix 1/2/2018 A1 12345 21212 Injection 2 Critical New Will Not Fix 2/6/2019 A2 12345 21212 Session Mgmt 3 Critical Existing Open 2/12/2019 A2 32165 321321 Session Mgmt 4 Critical Existing Open 5/8/2020 A3 32165 654654 Privacy Violation 5 High New Open 12/1/2020 A9 11111 654654 3rd party 6 Medium Re-Opened In Progress 1/16/2021 A9 11111 212121 3rd party 7 Low Existing In Progress 2/3/2021 A1 12345 321321 Injection I have been able to create the trend line data I am looking for with Excel formulas by running a count of every status every week. Here is an example of the data and trend that I am trying to reproduce in Power BI Any help on this would be greatly appreciated. Thank you, Eric
erhine1204
5 years ago Place DAX Commands and Tips
1.1KViews
0likes
1Comment