Exploring Clickable Manager Navigation Instead of Drillthrough
Hi, I've created a mock-up of a potential navigation experience for the AI Adoption Dashboard. The idea is that instead of using Drillthrough (which may be difficult to explain and adopt for leaders/managers), we make the Manager Name clickable, similar to a button or hyperlink. When a user clicks a manager, it would navigate to a dedicated manager details page showing: The selected manager's organization/team only A similar matrix view (without the leader slicer) Tool adoption counts and percentages Additional visuals such as bar charts showing adoption by AI tool Any relevant team-level insights The goal is to provide a more intuitive "click and explore" experience that f eels like navigating through the organization hierarchy, rather than requiring users to understand Drillthrough functionality. Would this type of page navigation be technically feasible in Power BI? Thank you for you help in advance
POWER BI REFRESH IN DESKTOP
Hi good morning, This error may seem to occur to many people but I haven't found any place where the solution is solved. When I try to refresh de data in power BI desktop with the button appears and error, different types of them. But, if you go to 'Transform Data' and refresh each of the queries one by one, the errors disappear. And then, going back to the report and press 'Refresh' everything is fixed, why? Thank you so muchWho logs in to PowerBI & to which reports - over a custom timeperiod?
Hello, I am wondering if I can track how frequent users login to/use PowerBI & which reports they have watched over a custom timeperiod (e.g. 1 year)? I understood currently that we can only view the reporting now over the past 3/4 weeks and that we need to do this analysis on report level (and cannot do it in bulk) Is this correcT? The goal is to understand which users really make use of PowerBI and of which reports and which users never login. Many thanks for your help & time upfront. KR, Charlotte
RANKX with SUMMARIZECOLUMNS and Filter
Hi all, Here is a sample of my dataset, where: - Job: one job can have multiple tasks, and be executed more than once in a day (job timestamp repeated). - Task: multiple tasks happen within a job. - Job TimeStamp: date and time the job started. One job can have multiple executions within a day. - Job Date: date the job started. - Job Status: can be either G or C. - Unique Key: concatenation between Job and Job TimeStamp. Here is a table I constructed using the following measures: G = CALCULATE(DISTINCTCOUNTNOBLANK(Table1[Unique Key]),Table1[Job Status]="G") Distinct Count Unique Key = DISTINCTCOUNTNOBLANK(Table1[Unique Key]) %G = IF([G]>0,[G]/[Distinct Count Unique Key],0) Average = CALCULATE([Distinct Count Unique Key], REMOVEFILTERS(Table1[Job]))/CALCULATE(DISTINCTCOUNTNOBLANK(Table1[Job]),REMOVEFILTERS(Table1[Job])) What I want to do a ranking of those jobs that are above average and below average. The jobs that are above average (Distinct Count Unique Key > Average), I want to create a table that contains the following: On the other hand, for those below average (Distinct Count Unique Key < Average): This ranking should be filtered with a slicer by Job Date. Ranking = VAR SummaryTable = FILTER( SUMMARIZECOLUMNS(Table1[Job],Table1[Job Date], "job_executions",DISTINCTCOUNTNOBLANK(Table1[Unique Key]), "job_failed_aborted",CALCULATE(DISTINCTCOUNTNOBLANK(Table1[Unique Key]),Table1[Job Status]="G"), "pcte_job_failed_aborted",CALCULATE(DISTINCTCOUNTNOBLANK(Table1[Unique Key]),Table1[Job Status]="G")/DISTINCTCOUNTNOBLANK(Table1[Unique Key])), [job_failed_aborted]>0) RETURN RANKX(ALL(SummaryTable[job_name]),[pcte_job_failed_aborted],,DESC) But it is not working. Could you please help me out? Thanks a lot! Best, S
