Alerts - traffic lights system

[Alexandra_B]

Hello everyone!

I am looking to create a dashboard with Alerts.

I have 257 JSON files so far (summed for 13 clients). I need to create alerts with the name of the client and two dots (flashing red - if the target is not reached/ data not recorded, green otherwise).

How could I group the data from this files to achieve the result?

Thank you.

[Alexandra_B]

Thank you very much, @Greg_Deckler  .

I used "Append Query" and then I was struggling a bit, until I realized that for the blinking dot I need to change the data category to "Image URL".

This is what I was looking for.

Thank you.

 

[Greg_Deckler]

@Alexandra_B Yeah, my free MSHGQM tool makes creating SVG stuff easier. Or the Enterprise DNA version, Quick Measures Pro.

[Greg_Deckler · Accepted solution]

@Alexandra_B Use an Append query? Or create a DAX table using UNION. Blinking lights can be done with SVG. https://community.powerbi.com/t5/Quick-Measures-Gallery/SVG-Animation-Bouncing-Blinking-Stephen-Few-...