One of the earlier posts referred to date hierarchies, a relatively new functionality that allows the month, quarter, or year to be automatically created based on a column containing a date (depending on the data that column contains). This can cause a problem with previous reports that contain dates, and the user wants to see them as originally created. How to solve this?
Conditional formatting is an option that has been gradually added to Table and Matrix visual. Now we can safely say that Power BI Desktop has almost everything we used in Excel to build the reports where we applied this option. As of July 2019, conditional formatting also supports icon sets, and in the text below you will be able to learn how to use all of these options.
We’ll use a quote from a familiar joke as an introduction to a problem you might encounter in everyday work: how to get the user to enter data only in a predefined cell group? There are several ways to achieve this, and one of the easiest is to format these cells in the desired manner (eg, set a specific background color) and to prevent entry into the cells that are not formatted in a given manner.
How do I remove set of values from the table? In practice, sometimes we encounter a scenario where it is necessary to remove from the list of entities one or more of the values specified in an ancillary records. For example, in the first list there is a list of workers, and in the second list of workers that need to be removed. How to perform this without having to manually remove one by one from the table?
When creating tables, we often use our own markup, e.g. change the cell background color of the data we want to indicate in some way. How to automatically count them later? If we applied a filter or these cells are within a structured table, it is enough to filter the table by color, so that we can use SUBTOTAL function to find out how many cells are colored in a certain way. Can this also be done using COUNTIF?