Forum Discussion
Helper IIIAlerts - traffic lights system
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 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-Red-Dot/m-p/517631#M221
3 Replies
Alexandra_BThank 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
Community Champion
Alexandra_B Yeah, my free MSHGQM tool makes creating SVG stuff easier. Or the Enterprise DNA version, Quick Measures Pro.
- Greg_Deckler
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-Red-Dot/m-p/517631#M221