Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi All,
I have a series of tasks 1 to 60 (rows) with different dead lines (datetime) and different locations (attribute) record 'done' when they have completed the task.
The requirement is if 'done' is not entered by the deadline then the KPI should be red, once 'done' is entered either before the deadline or after it turns green and I can only use the standard visuals provided in PBI. So I'm not sure if this is possible with the standard KPI visual.
Table name: Data | ||||
Task Number | Date | Attribute | Time deadline (AEST) | Value |
1 | 21/04/2022 | Office1 | 31/12/2022 12:00pm | Outstanding |
2 | 22/04/2022 | Office2 | 31/12/2022 12:00pm | Outstanding |
1 | 21/04/2022 | Office3 | 31/12/2022 12:00pm | Done |
3 | 22/04/2022 | Office2 | 31/12/2022 12:00pm | Outstanding |
tried adding column to table but can't mix data types text & date;
KPI Column = IF('Data'[Deadline] > time(hour(now()),minute(now()),second(now()) && 'Data'[Value] = "Outstanding", 1,0)
I'm out of ideas so thanks for any assistance.
The date and deadline columns are not the same type? One of them is Text for some reason? If yes, change it to data or datetime before you bring it to the model (in Power Query for example).
Than you sould be able to write something simple like:
KPI Column = IF('Data'[Deadline] > 'Data'[Deadline] && 'Data'[Value] = "Outstanding", 1,0)
Also you don't need a column for that calculation, do it in a measure and than use it in the conditional formating settings of the visual:
User | Count |
---|---|
25 | |
11 | |
8 | |
6 | |
6 |
User | Count |
---|---|
27 | |
13 | |
11 | |
9 | |
6 |