Power BI: How to Enable Cross-Filtering in Both Directions

If your data doesn’t have a unique ID like a primary key, then it is usually a good idea to add an index column to your table. This is especially important when you want to have 1-1 relationships between tables. An index column is a column that has incremental numbers in the rows. It can…

In the report view, when you have multiple visuals on the same sheet, sometimes there is a need to have some visuals that are somewhat fixed and do not change when the filters are changed. This is especially useful when there are multiple filters and slicers to cut the data. Examples would include benchmark values…

The matrix table is a common visualization used in most dashboards. It can help aggregate data into a pivot table format making it easier to see data in a tabular format. By default, when you create a matrix table, the totals will show in the table. In many cases, you may want to remove these…

Slicers are a great way to allow the users of your dashboard to slice and dice the data as they wish to get better insights. Whenever we use a field in the slicer, you may be in a situation where you see the (Blank) field. This happens whenever you have null or blank values in…

When your dataset is very large, there is a chance that there are duplicate rows of data that may cause inaccuracies when you aggregate data in your analysis. It is a good idea to remove duplicate rows as part of the data clean up process before developing your dashboard. By duplicate rows, we mean that…

Slicers are visual filters that you can use to easily filter your visualizations in the dashboard. When creating a slicer in Power BI, we have multiple options that we can see the slicer as: You can also change the options for your slicer to be single select or multi-select. There’s also an option to show…