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[…]
Anomaly detection is one of the popular topics in machine learning to detect uncommon data points in the datasets. For example, in a greenhouse, the temperature and other elements of the greenhouse may change suddenly and impact the plant’s health situation. Identifying the anomaly data in a credit card transaction, or in health data received Read more about Anomaly Detection in Power BI[…]
If you have a visual in the Power BI, that based on some selections of a slicer it might return nothing, depends on the visual, you might get a blank visual, or some other types of improper view. In this blog, I share a simple trick that you can use to have an alternate message Read more about Showing an alternate text when no data available in a Power BI chart visuals[…]
Can you change the format of a measure or a value in Power BI dynamically? Is it possible to set a value to be a percentage sometimes, and sometimes to be a currency? can you change the currency format? The answer to all these questions is yes. In this short blog, I am going to Read more about Dynamically change the format of values 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[…]
Did it happen to you that you have calculated a cumulative total (such as running total, or year to date, etc) either using the quick measures or by writing the DAX expression yourself, and then realizing that the calculation happens even for the periods without any real data? For example, you want to stop that Read more about Stop DAX Cumulative Total Calculation in Power BI[…]
If you even need to show your DAX measures in a chart without a dimension to slice and dice it, you won’t get a great experience in the visual. In this blog post, I’ll share a trick that you can use to have a nice visualization like what you see in the above screenshot. How Read more about DAX Measure in the Axis of the Power BI Report[…]