To achieve this, I added 2 logical checks to the beginning of your Label calculation
ISNULL(sum([Page Load Speed Alerts])) then ''
This one checks if the current value is null and allows the new calc to resolve to nothing for that row (Q2)
elseif ISNull(LOOKUP(SUM([Page Load Speed Alerts]),-1)) then "no data"
This condition sets a "no data" result if the previous value in Period is null
Then I set the color for the Blank/Null to be white so it is invisible and gave the "no data" this colored dot.
My workbook is attached so you have the whole calc. Hope this helps!
If null show no data.twbx 41.5 KB
Thank you so much, It is almost solved. The calculation solves the 2nd task (when there is no data) - see image below
But, How can I also solve the 1st task (when there is data). How can I hide/delete the blue ball below when there is data? -see image below
PS. I do not need the text label, I just need to delete/hide the blue ball. If I change the color of "no data" from blue to white, then it also affects/brakes the 2nd task (see image above)
Any ideas on how to have 2 different names? I.E. "no data" and "yes data", so I can change the color of 'yes data' to white without changing the 'no data' blue color?
Thank you so much
Ah, I think I see what you mean. What if change the first condition to check for index()=1? That would mean the first row always gets treated as blank, regardless of if there is data or not. Then the 2nd condition looks for no data in the previous row, and then your logic is evaluated.
That would treat the first row as blank with or without data
Is this what you're looking for?
If null show no data.twbx 42.1 KB
Yes. That is exactly what I am looking for. Thank you so much