Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi
this should be simple....cannot understand why it isnt.
i want to produce a bar chart, x axis is day of month, y-axis is total count of events over the day.
if the total count is above a set target, i want the bar green. if below, red.
I thought i could create a measure to say sum the total count over the day - but for some reason it does not let me do this....i woiuld then do: green column= if(count>target, count,0) and red column = if(count<target,count,0)
i cant even select the [count] column when i try create a measure....so i tried creating a column instead and gives me incorrect data.
why cant i select [count] when i create a measure?? help please - going insane!!
Hi @hugus ,
Does constant line meet your requirement?
no this doesnt do it....the line will need to be different for each day as the target is changing....
Hi @hugus ,
Where the target comes from? Does using a What if parameter work in your scenario?
User | Count |
---|---|
141 | |
113 | |
104 | |
78 | |
64 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |