topic Re: KPI - coloration by measure field name in App Development

KPI - coloration by measure field name

matthi0uw — Sat, 16 Nov 2024 06:34:51 GMT

Hi,

In KPI, there is 2 measures and conditional coloration :

This exemple displays :

measure1 = sum(dim1)
measure2 = sum(dim2)

If I change the formula (measure1 = sum(dim3), I have to change 2 fields.

Is it possible to set condition by name of field ({measure1} or something like that) instead of name of dimension (dim1) or expression sum(dim1) to avoid missing change ?

Matthieu

Re: KPI - coloration by measure field name

Anil_Babu_Samineni — Mon, 18 Feb 2019 04:14:20 GMT

Please create those measures in Master Item and apply the (Hex) code for that. That deserved the same.

If you want to limit data level, My suggestion to go like yours with conditions instead static.

Re: KPI - coloration by measure field name

matthi0uw — Mon, 18 Feb 2019 17:01:50 GMT

Your idea need a master item for each kpi if I understand correctly and I already use dynamic conditions.

I will try to explain another time with steps and example:

Create my KPI
Add 1st number : sum({ $<id_periode=2019>}[sales])
Add 2nd number : sum({ $<id_periode=2018>}[sales])
Add % as label of 2nd number : Num( sum({ $<id_periode=2019>}[sales]) / sum({ $<id_periode=2018>}[sales]) ) - 1 , '0,00%')
Add color and symbol :
1. value < threshold1 = symbol 'arrow down' + 'orange'
2. threshold1 < value < threshold2 = symbol 'arrow right' + 'light blue'
3. threshold1 < threshold2 < value = symbol 'arrow up' + 'dark blue'.

with:

threshold1 = sum({ $<id_periode=2018>}[sales])
threshold2 = sum({ $<id_periode=2018>}[sales])+1

When I change something, I have to change 1st number, 2nd, % and colors. Is it possible to say something like : threshold1 = {1st-number} ?