Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello All,
I do have multiple KPI cards (lets say 5 Cards) wanted to create a conditional formatting based on the 5 KPI values.
lets say
KPI card 1 Values : 10
KPI card 2 Values : 20
KPI card 3 Values : 30
KPI card 4 Values : 40
KPI card 5 Values : 50
Based on the above values the KPI card 5 Values which is 50 should be color formattied and highlighted .
any suggestion ?
@sumachintalapan , Not very clear
but you can have measure like these and use that in conditional formatting using field value option
KPI1 color = if( [KPI1] = maxx({[KPI1], [KPI2],[KPI3], [KPI4],[KPI5]}, [Values]), "Green", "Black")
KPI2 color = if( [KPI2] = maxx({[KPI1], [KPI2],[KPI3], [KPI4],[KPI5]}, [Values]), "Green", "Black")
can you please share some example PBIX file if you have any . Thanks.
User | Count |
---|---|
98 | |
90 | |
77 | |
71 | |
64 |
User | Count |
---|---|
114 | |
98 | |
96 | |
68 | |
67 |