I have previously explained that we have three scopes of filtering in the Power BI visualization. The filter created in the filter pane can be often changed or viewed by the user. However, there is a simple way to hide or lock it from the user. In this article and video, I explain how that Read more about Power BI Visualization Tip: Hide or Lock the Filter for Users[…]
If you build a report for an enterprise, you might be limited to use the organization-approved colors. It is also useful to have your reports following a template of colors, and fonts, which might look like your signature of the report. In Power BI, you can do that with Theme. In this article, I’ll explain Read more about Power BI Theme: Customize Colors, Fonts, and Visual Appearance for Multiple Objects[…]
For a visualization tool, one of the important factors is to filter the data for a specific reporting requirement. Power BI gives you this ability by the Filters pane in the visualization. There are, however, three scopes of filtering, which you need to be aware of. In this short article and video, I explained how Read more about Scope of Filter in Power BI Report[…]
This is a very short, simple article about how to have a multi-select slicer in Power BI. Power BI slicer is in fact multi-select by default, however, there is a very small option that if you set it, makes it even easier to use, let’s talk about it. If you want to learn more about Read more about Multi-Select Slicer in Power BI[…]
Regarding using Charticulator for creating custom visuals, I come across one of the visuals in the Charticulator gallery and I decided to follow it up to see how it created. So I manage to create a dataset that has ranking, name and amount. https://charticulator.com/gallery/co2_emission_ranking.html In this example, I am using Carbon dioxide emission data for Read more about Ranking Chart in power BI Desktop Using Charticulator[…]
In this post series, I am going to show how to use new Q&A visuals for the aim of creating easy visuals by typing the natural language and define some user-defined terms and how to manage it. This visual is now generally available for everyone. IN this post some introduction to this visual about how Read more about Q&A Visual in Power BI Desktop[…]
Yesterday, I published a post about having a slicer that filters the rows in a table visual in Power BI that contains the characters from that slicer. A friend asked me what if we want to search for the first few characters? that means selecting the first character, then seeing all the possible second characters, Read more about Search for All the Texts in Power BI Table Visual with the First Three Characters Selected in the Slicer[…]
If you have a lot of text in a table visual in Power BI and want to search to find all texts with a specific character in it, I have a solution for you. You can have an alphabet slicer and use it to filter the table visual, the trick is to combine it with Read more about Search in Power BI Table Visual Using a Slicer For Contains Character Criteria[…]
Previously, to create page navigation in Power BI, you needed to create bookmarks, and buttons to action to that bookmark. However, recently, in the last version of Power BI Desktop, the ability to easily navigate to other pages using Buttons in announced. In this short article, I’ll explain how you can use this approach to Read more about Page Navigation Buttons in Power BI[…]
You can change the font size of a visual easily by going to the format option of that. However, if you want to change it for multiple visuals, better to use Themes for it. Recently Power BI Desktop came up with some easy-to-use options to customize your theme. That means you can now easily increase Read more about Change The Font Size or Color Across All Visuals and Pages in a Power BI File[…]