Power BI

Power BI

9059 bookmarks
Custom sorting
How To Make ELEGANT In Page Navigation With Power BI Bookmark Navigator
How To Make ELEGANT In Page Navigation With Power BI Bookmark Navigator
In this video, I’m going to show you how to make a very attractive in-page navigation in Power BI using BOOKMARK NAVIGATOR. Follow the steps and let’s learn how to make this awesome feature.   ExcelFort - YouTube     Hope this article/video was helpful to you? Please leave your comments, suggestion...
Power_BI_tips·community.powerbi.com·
How To Make ELEGANT In Page Navigation With Power BI Bookmark Navigator
How to add MapBox Basemaps to Icon Map for Power BI — DiscoverEI
How to add MapBox Basemaps to Icon Map for Power BI — DiscoverEI
In this short video blog we walk through how to create custom basemaps in MapBox and integrate them into your Icon Map in Power BI! We then take it to the next level by configuring dynamic basemaps which we can change using slicers. A big shoutout and thanks to James Dales for creating this awesome
Power_BI_tips·discoverei.com·
How to add MapBox Basemaps to Icon Map for Power BI — DiscoverEI
Deep Dive into InfoRiver Export to Excel
Deep Dive into InfoRiver Export to Excel
This is a further article in my series where I share with you what I have learnt about the InfoRiver custom visual.  As good as Power BI is, it will take Microsoft many more years to make it fully featured.  Microsoft Excel is 37 years old, and I can assure [...]Read More »
Power_BI_tips·exceleratorbi.com.au·
Deep Dive into InfoRiver Export to Excel
Highlight values, Smart narrative, Great Power BI storytelling technique
Highlight values, Smart narrative, Great Power BI storytelling technique
I just tested the technique shared by Ruth from Curbal, using the smart narrative to do storytelling in Power BI in order to to catch the user's attention and deliver insights more effectively. The goal is to highlight the selected categories. In a bar chart it's easy since it includes conditional formatting allowing to do it flexibly.
Power_BI_tips·amalbenrebai.substack.com·
Highlight values, Smart narrative, Great Power BI storytelling technique
PowerBI Custom Chart Ranges
PowerBI Custom Chart Ranges
My go to progress dashboard calculates a lot of progress % metrics and graphs. However for larger projects, its often difficult to zoom into the graph. This is exactly why slicers exist
Power_BI_tips·datamonkeysite.com·
PowerBI Custom Chart Ranges
Thinking about target bands - EXPLORATIONS IN DATA STORYTELLING WITH POWER BI
Thinking about target bands - EXPLORATIONS IN DATA STORYTELLING WITH POWER BI
I’ve come across many charts like this in the wild. They’re not bad charts, they serve a purpose, but they could be better.  Bar charts are created by encoding data by length. It is commonly thought that when people read bars, they are comparing length, not position. The axis starts at 50%, rather than zero,… Continue reading Thinking about target bands
Power_BI_tips·kerrykolosko.com·
Thinking about target bands - EXPLORATIONS IN DATA STORYTELLING WITH POWER BI
How To SWITCH Power BI TOOLTIP PAGE | Made EASY With Bookmark Navigator
How To SWITCH Power BI TOOLTIP PAGE | Made EASY With Bookmark Navigator
Using the bookmark navigator, I will show you how to let your users choose what is displayed on the tooltip according to their preferences. By using this approach, you are able to switch easily between different tooltip pages without having to create multiple tooltip report pages SUBSCRIBE AND WATC...
Power_BI_tips·community.powerbi.com·
How To SWITCH Power BI TOOLTIP PAGE | Made EASY With Bookmark Navigator
Power BI + Adobe = Magic - EXPLORATIONS IN DATA STORYTELLING WITH POWER BI
Power BI + Adobe = Magic - EXPLORATIONS IN DATA STORYTELLING WITH POWER BI
Adobe Illustrator has been a tool in my dashboard design kit for quite a while. I’ve used it predominately for creating report assets such as icons, headers and backgrounds. I’ve also used it to create SVG visual elements such as the dice, turbine and scatter plot shapes and markers pictured below. But there’s another way… Continue reading Power BI + Adobe = Magic
Power_BI_tips·kerrykolosko.com·
Power BI + Adobe = Magic - EXPLORATIONS IN DATA STORYTELLING WITH POWER BI
Beyond Precision: Expressiveness in Visualization
Beyond Precision: Expressiveness in Visualization
Using precision as guidance for visualization design is powerful and yet limited in many different ways. Expressiveness may help.
Visualization is about mapping data values to visual channels;
While precision is a useful factor to keep in mind, it’s neither sufficient nor necessary to create effective visualizations.
First, it’s not always true that visualizations that use position are “better” than those that do not. Second, position can be expressed in multiple ways, so the guidelines leave us unable  to discern between visualizations that use position differently.
The problem with guidelines based on precision is that visualization is not really about precision.
But visualization is less about precision, and much  more about what the visual representation expresses.
data contains information that we want to communicate, and that information is what we want to  “express” with visual representations
Good visualizations stem from a good matching between what we want to express and what the visual representation expresses (something highlighted in the foundational work of Jock Mackinlay, who I believe introduced the term in the first place).
Expressiveness is much more about finding a good match between visual properties and “concepts” than precision or accuracy.
diverging color scale is not a matter of precision or accuracy (in fact a diverging color scale may even be less precise!), it’s a matter of good semantic matching; a matter of expressiveness.
The book divides visual channels into two large groups, magnitude channels and identity channels, according to whether they are more appropriate for quantitative or categorical information. For example, if I want to express a quantity, I shouldn’t use color hue, because humans do not perceive hues as ordered). And if I want to express categories, I shouldn’t use symbol size, because we naturally associate sizes with quantities, not categories.
Let’s look at other things one may want to express. Without any pretense to be exhaustive, here are some examples off the top of my head: Directionality: can the values be positive or negative? Is there a zero value or a meaningful threshold? Part-to-whole: do the data objects represent the part of a whole? Order: are the objects organized in a meaningful order? Grouping: are the objects organized around a set of meaningful groups Space/time: do the objects represent space or time or space-time phenomena?
But position expresses information in so many other important ways! Think about position on a single axis versus an orthogonal pair of axes; position in polar coordinates; position on a map; position to express grouping and alignment; etc.
Pursuing expressiveness may ultimately lead to inelegant or irrelevant findings, who knows. But it may also open the doors to a much richer description of how visualization works and to much better guidance.
we have to keep in mind that expressiveness is not only useful in figuring out how to express the information and ideas we want to communicate, but it is equally useful in making sure we do NOT accidentally convey information we did not intend to express.
We can work towards having a better and more complete characterization of what information and concepts we typically want to communicate with data and, similarly, develop a better understanding of what visual properties exist and what they express.
The more granular we go, the harder it is to generalize. In addition to that, the impulse to be able to describe every possible situation may backfire by making things more complicated than they need be.
Once we have a better description of data concepts and visual features, how do we build guidelines that can help people think more productively about visualization design?
Finally, if we want to approach this problem scientifically, we will also need to verify that guidelines and models based on expressiveness have a measurable impact on visualization effectiveness. For instance, it would be useful to explore if, among two competing visual representations, the one having a better match in terms of expressiveness leads to a difference  in comprehension (which is not easy to measure, but that’s a different story).
We do not visualize data, we visualize ideas based on data, and we need a better mental model (and maybe even a theory) to design visualizations.
Power_BI_tips·filwd.substack.com·
Beyond Precision: Expressiveness in Visualization
Asking the right data questions and asking the data questions right
Asking the right data questions and asking the data questions right
In my last post I lamented the fact that there is too little focus on data thinking in data science and data visualization, and I described how much of a struggle it’s been for me to figure out how to learn and teach these skills. When I teach my academic visualization course, the thing the most exemplifies this need is the way I struggle to teach how to formulate good
Power_BI_tips·filwd.substack.com·
Asking the right data questions and asking the data questions right