data visualization - Power BI Visualisation and Formating -


hi there i'm quite new power bi wanted ask advice on approach visualising data.

1) group values display indicator (green or red) depending on value.

for example: vm running= green vm deallocated= red

2) , list machine names dataset report under each indicator

and example of actual test data below visualise:

test data

and example of visualisation want create:

an example visualisation

any advice on approach or how achieve in ms powerbi?

thanks!

to want, think need create own custom visual.


since creating custom visual takes time figure out, explored options existing resources , able create close-ish want. custom visual report, click on "home" -> "from store" (in custom visuals group)

custom visual

in dialog pops up, search "dot plot" , click on "add" "dot plot okviz" visual.

dot plot

you see new icon in visualization panel.

new visualization

before use visualization, let's @ data used. created sample data similar in structure yours , added 1 column using below dax formula.

value = rankx(attendance, attendance[class],, asc, dense) 

data

now create new dot plot , fill in fields show below.

fields

that results in looks this.

visual

you can change black circles red, clicking on paint roller icon between visualizations panel , data panel.

new color

from there, how want present it. did additional tweaking formatting , added cards class name (configured shown below)

cards

in end, this.

results


you split class (group) , looks this.

other result


Comments

Popular posts from this blog

PHP and MySQL WP -

android - InAppBilling registering BroadcastReceiver in AndroidManifest -

go - golang pprof for c library code -