Read our blogs, tips and tutorials
Try our exercises or test your skills
Watch our tutorial videos or shorts
Take a self-paced course
Read our recent newsletters
License our courseware
Book expert consultancy
Buy our publications
Get help in using our site
551 attributed reviews in the last 3 years
Refreshingly small course sizes
Outstandingly good courseware
Whizzy online classrooms
Wise Owl trainers only (no freelancers)
Almost no cancellations
We have genuine integrity
We invoice after training
Review 30+ years of Wise Owl
View our top 100 clients
Search our website
We also send out useful tips in a monthly email newsletter ...
5 interesting custom visuals in Power BI Dektop |
---|
Basic Power BI Desktop visuals can leave something to be desired. Try these 5 visuals to spice up your reports! |
In this blog
Power BI Desktop comes with some great in built-in visuals but sometimes we need a little something more. Here are a few of this owl's favourite visuals you should check out.
This classic looking visual will be popular with users of SSRS who dislike the Power BI Gauge. It uses blocks of colour to track performance in traffic light colours:
Use up to 3 ranges based on data to track live performance.
Instead of using it with ranges you can use solid blocks like the original Power BI gauge, but with more control over the colours:
Compare an individual to the highest and lowest performing on a team.
An alternative is the Dial Gauge which I found hard to get working.
This is probably the most practical of the custom visuals in this list, and adds a nice animation to reports. The visual provides a slicer that scrolls through the filter field you give it:
This slicer will automatically show each year, filtering visuals on the page for each.
If you find the default options unappealing you can change a whole host of settings including time spent on each level, auto scroll and even button colours!
You could even have corporate colours for the buttons or multiple slicers!
Whilst the standard map is fine for visualising, it doesn't have heat map options. ArcGIS does, but some of the options are paid for whilst this one is free.
The visual includes a host of options including the kind of map (aerial, road etc) and turning town names on and off.
If contour maps aren't your thing it is also possible to turn on heat maps. Change the size of the rings and colours to suit.
Dark mode always strikes this owl as only useful for tracking night-time road crashes.
The second slicer that has snuck onto this list, but this time it is more form than function. This handy slicer lets you combine images with your data into a slicer.
Perfect for using with company logos for filtering.
A handy feature with this visual is since it is data driven you can filter the visual just like any other.
It appears 2010 was a good year for reptile sales only. Perhaps Rango was released that year.
Reaching here you deserve a reward: something relaxing perhaps? The Enlighten Aquarium embodies form over function and shouldn't be taken too seriously.
Up to three values can be visualised for a single field - in this case average quantity and price for each region.
All the fish of the same category are the same colour. With a choice of triangular fish, round fish or sharks, how can anyone dislike watching the fish swim around?
Just for fun, I've included a report combining all five visuals!
With a bit more formatting it will be ready to hand in!
Go and check out the wealth of custom visuals available through the Microsoft office and choose your own top 5 ...
Some other pages relevant to the above blog include:
Kingsmoor House
Railway Street
GLOSSOP
SK13 2AA
Landmark Offices
99 Bishopsgate
LONDON
EC2M 3XD
Holiday Inn
25 Aytoun Street
MANCHESTER
M1 3AE
© Wise Owl Business Solutions Ltd 2024. All Rights Reserved.