Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
A telecom company has a packet core KPI monitoring system called U2020 (Huawei). It generates some KPIs during busy hours. Currently, it is linked to three main telecom nodes: USN9810, USN02, and Cloud USN (vUSN). In some cases, only one node generates KPIs, while others do not (Node 3 does not need to generate KPIs all the time). However, the attached KPI file contains cleansed KPIs, as shown in the table below. Please create a PowerBI dashboard to monitor these KPIs. For your reference, the data will be updated on a daily basis.
Example:
MAIN_KPI_NAME | RESULT_DATE | RESULT_HOUR | NODE_NAME | KPI_NAME | KPI_VALUE |
Gb_mode_attach | 2023-06-05 | 18 | USN02 | Gb mode GPRS attach success rate | 72.506 |
Gb_mode_attach | 2023-06-05 | 18 | USN9810 | Gb mode GPRS attach success rate | 79.879 |
Gb_mode_attach | 2023-06-05 | 19 | USN02 | Gb mode GPRS attach success rate | 73.782 |
Gb_mode_attach | 2023-06-05 | 19 | USN9810 | Gb mode GPRS attach success rate | 80.732 |
Gb_mode_attach | 2023-06-05 | 20 | USN02 | Gb mode GPRS attach success rate | 73.637 |
Gb_mode_attach | 2023-06-05 | 20 | USN9810 | Gb mode GPRS attach success rate | 80.972 |
Gb_mode_attach | 2023-06-05 | 21 | USN02 | Gb mode GPRS attach success rate | 73.226 |
Gb_mode_attach | 2023-06-05 | 21 | USN9810 | Gb mode GPRS attach success rate | 80.557 |
Solved! Go to Solution.
Hi, @mosam
You can try the following methods.
Measure color = Var _minvalue=CALCULATE(MIN('Table'[KPI_VALUE]),ALLEXCEPT('Table','Table'[NODE_NAME]))
Return
IF(SELECTEDVALUE('Table'[KPI_VALUE])=_minvalue,"Yellow",BLANK())
Apply font conditional formatting to all fields.
Result:
Is this the result you expect?
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, @mosam
You can try the following methods.
Measure color = Var _minvalue=CALCULATE(MIN('Table'[KPI_VALUE]),ALLEXCEPT('Table','Table'[NODE_NAME]))
Return
IF(SELECTEDVALUE('Table'[KPI_VALUE])=_minvalue,"Yellow",BLANK())
Apply font conditional formatting to all fields.
Result:
Is this the result you expect?
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
User | Count |
---|---|
105 | |
98 | |
97 | |
68 | |
34 |
User | Count |
---|---|
146 | |
141 | |
116 | |
98 | |
52 |