11 Power BI Visualization Tricks You Need to Know!

In this video, I will share 11 awesome visualization tricks in Power BI that you will love. These tips will help you save time and increase your productivity.

===== ONLINE COURSES =====
✔️ Master 'M' in Power Query -

✔️ Mastering DAX in Power BI -

✔️ Power Query Course-

✔️ Master Excel Step-by-Step-

✔️ Business Intelligence Dashboards-

===== LINKS 🔗 =====

===== CONTACT 🌐 =====

===== WHO AM I? =====
A lot of people think that my name is Goodly, it's NOT ;)
My name is Chandeep. Goodly is my full-time venture where I share what I learn about Excel and Power BI.
Please browse around, you'll find a ton of interesting videos that I have created :) Cheers!

[officesuperhero]

Ive been using Power BI for about 8 years and I learned a few new tips! Thank you!

[muhammadathar]

Thanks a lot, your videos are always very helpful.

[chrism]

Awesome Chandeep! Number 10 was the best

[bharathreddy]

Apply slicers is my take away .. thanks

[markdhenderson]

Pivot Table Classic Layout (putting nested rows beside top row content) -> 0:51

[valentino]

Thx for trick no. 2. It is the same as tabular view on pivot table.

[williamarthur]

Thank you for this, especially re 'pivot table ' layout, I often end up just using power pivot as I get so frustrated trying to find things in the Pbi visual setting / format .

[kunalr_ai]

This video talks about five useful tricks to use the DAX function.

**Key points:**

* Reverse filters from the facts table to the dimension table using expanded tables.
* Fixing the nasty totals that Power BI often gives out as wrong using visual level calculations.
* Using the Max and the Min functions smartly instead of writing long if statements.
* Removing the spillover effects of calculation using a check column.
* Finding duplicate rows based on a certain criteria using the group by function.

**Examples discussed:**

1. **Reverse filters:** Creating a measure to calculate the distinct count of products bands, applying the filter to the sales table which expands to include all columns from the products table.
2. **Fixing totals:** Creating a visual level calculation to calculate the running total of max regional sales, identifying and correcting the incorrect total.
3. **Max and Min functions:** Using the Min function to calculate the minimum amount to pay off a loan based on income and loan amount, using the Max function to calculate commission based on profit while avoiding negative values.
4. **Removing spillover effects:** Creating a check column to filter out YTD values for months without sales data.
5. **Finding duplicate rows:** Using the group by function to identify duplicate rows based on date and product ID, counting the occurrences of each combination and sorting the results.

**Steps:**

1. **Reverse filters:**
* Create a measure with the distinct count of the desired column.
* Wrap the measure in the CALCULATE function with the fact table as the filter.
2. **Fixing totals:**
* Create a visual level calculation for the running total.
* Define the calculation formula, axis, blanks handling, and reset conditions.
* Wrap the calculation in the ADDCOLUMNS function to add it to a summarized table.
* Use the SUMX function to calculate the total based on the summarized table.
3. **Max and Min functions:**
* Use the MIN function to determine the smaller value between two options.
* Use the MAX function to select the larger value between a calculation and a blank.
4. **Removing spillover effects:**
* Create a check column with a DAX formula that evaluates the condition for the spillover effect.
* Format the column to hide the values where the condition is not met.
5. **Finding duplicate rows:**
* Use the GROUPBY function to group the data by the desired columns.
* Create a new column within the grouped table to count the occurrences of each combination.
* Sort the table by the count column to identify duplicates.

[FarhanMerchant]

Fabulous insights and tricks ; your videos are so crisp and so knowledgeful; thank you for sharing

[randomguy-jovq]

Enrolled for your course 😊 your way to explain things is super easy to understand and soothing

[excelWithFaiyaz]

Alt Shift F11
Classic pivot table view, stepped layout
Using the shift key to align
Using align options

Using sort columns in table for multiple columns using the shift key to align
10:00 filter by field parameter

[APG-ql]

Excelente tutorial. Enhorabuena y muchas gracias.

[MrJunaidtayyab]

Field Parameters took me off guard. Thanks for explaining this useful feature.

[powerbinareal]

Impressionante como pode ter tantas dicas em um só vídeo #powerbinareal

[Brescianello]

I don't have the "step layout" formatting feature in the row headers section in my PowerBI Desktop (version july 2024). To be able to have the Pivot table "effect" (trick #2) I have to choose "tabular" in the Layout and Style preset.

[mogilirajesh]

Hi Chandeep,

All the tricks are awsome. could you please tell me the use case of using format function for turning random numbers to "true/false" or "on/off"

[AsmaaMGaber]

Hi, can you make a video on how to highlight selected column based on slicer with calculation group?

[IvanCortinas_ES]

Is it possible 2 Likes? This is very good, even knowing the tool!! Thanks Chandeep!!

[FannieuN]

Number 10: once you selected a Region (New Delhi) and switch back to Channel, hope the selection will remain the same in the TABLE

[tauhidanwar]

Very informative video. I have one query regarding exporting data. I am using power bi server and I can only download to 150k rows while exporting to excel from the report. Is there any way to increase the rows? Waiting for your response very much 😊.Thanks again for the tips and tricks