Scenario:
I’m going to share with you a little trick, just make a clock visual with DAX.
The visual looks like this:
Operation
The operation steps are as follows:
- Create a new table as the hour slicer of clock visual.
clock = GENERATESERIES(1, 24, 1)
- The most important is to use the characteristics of UNICHAR function to dynamically display different vision
clock =
var hours = SELECTEDVALUE(clock[Hour],1)
var _12h = IF(hours>12,hours-12,hours)
return UNICHAR(128335+_12h)
- Drag this measure into card visual and then will show a clock visual.
Unicode table used
Here is the Unicode of the clock. We can change the visual of the clock by changing the value of the Unicode.
Clock Symbol |
Clock Name |
Decimal |
🕐 |
Clock Face One Oclock |
128336; |
🕑 |
Clock Face Two Oclock |
128337; |
🕒 |
Clock Face Three Oclock |
128338; |
🕓 |
Clock Face Four Oclock |
128339; |
🕔 |
Clock Face Five Oclock |
128340; |
🕕 |
Clock Face Six Oclock |
128341; |
🕖 |
Clock Face Seven Oclock |
128342; |
🕗 |
Clock Face Eight Oclock |
128343; |
🕘 |
Clock Face Nine Oclock |
128344; |
🕙 |
Clock Face Ten Oclock |
128345; |
🕚 |
Clock Face Eleven Oclock |
128346; |
🕛 |
Clock Face Twelve Oclock |
128347; |
🕜 |
Clock Face One-thirty |
128348; |
🕝 |
Clock Face Two-thirty |
128349; |
🕞 |
Clock Face Three-thirty |
128350; |
🕟 |
Clock Face Four-thirty |
128351; |
🕠 |
Clock Face Five-thirty |
128352; |
🕡 |
Clock Face Six-thirty |
128353; |
Tips
You can also use the UNICHAR function and other Unicode to create the visual you want.
Be the first to comment