Forum Discussion
How to visualise binary values from live dataset?
For clarity's sake, I'll simplify the case as following:
- I have a live dataset that sends binary values that tells if a device is on or off
- A single column in the datased represents a single device
With my limited skills I can create DAX measures that show the latest value and visualise them as Cards. However, I would like to visualise the values as a Matrix/table as following:
| Device name | Status |
| Device 1 | 1 |
| Device 2 | 0 |
| Device 3 | 1 |
Also, it would be even better if the status could be shown with different color (or icon) depending on the value.
Any ideas how to make this happen? Please note that I'm using a Live Dataset, which means I'm limited to DAX only...or was it that nowadays I can use DirectQuery on live dataset?
2 Replies
lehikk , you can create a column/measure like
new column = if([Status],1,0) or measure = maxx(Table,if([Status],1,0) )
Also, you can do conditional formatting like
new column = if([Status],"Green","Red") or measure = maxx(Table,if([Status],"Green","Red") )
You can return a unichar for shape or use icon formatting
https://www.youtube.com/watch?v=veCtfP8IhbI
refer for more details on conditional and icon formatting
https://exceleratorbi.com.au/conditional-formatting-using-icons-in-power-bi/
https://community.powerbi.com/t5/Desktop/FORMAT-icon-set-for-use-in-a-data-card/td-p/811692
https://exceleratorbi.com.au/dax-unichar-function-power-bi/Hi lehikk ,
Do you have an index or date column that could identify that this row is the latest one?
Best Regards,
KellyDid I answer your question? Mark my post as a solution!
