Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Within the pivot table, I have a measure XY, whose formula is this. Based on the value my data are colored in red, green and blue color.
If(
[Robna marka naziv] = 'test',
If(
(120/((Sum([Iznos nabavno]))/((Sum([Stanje financijsko 2024])/12)*4)))/30 > 4.9999,
rgb(255,0,0), // Crvena boja ako je iznos > 5
If(
(120/((Sum([Iznos nabavno]))/((Sum([Stanje financijsko 2024])/12)*4)))/30 < 2.9999,
rgb(35,78,222), // Plava boja ako je iznos < 5
If(
(120/((Sum([Iznos nabavno]))/((Sum([Stanje financijsko 2024])/12)*4)))/30 >= 2.9999
AND (120/((Sum([Iznos nabavno]))/((Sum([Stanje financijsko 2024])/12)*4)))/30 <= 4.9999,
rgb(0,255,0), // Zelena boja ako je između 3, 4 ili 5
null() // Ostatak nema boju
)
)
),
How can I represent within the pie chart the amounts of red, blue, and green colors?
You can create a dimension
valuelist('red','blue','yellow')
and the expression
You can create a dimension
valuelist('red','blue','yellow')
and the expression