📌My Top 5 Power BI Mistakes (and how to avoid them) - ua-cam.com/video/ZIbK5MuLSfM/v-deo.htmlfeature=shared ⬇Download the file - goodly.co.in/power-bi-visualization-tricks 📊Interested in tackling tough problems in Power BI? Enroll in my DAX and Data Modeling course today - goodly.co.in/learn-dax-powerbi/
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 .
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
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. googleusercontent.com/youtube_content/1
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.
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"
Hi Sir, I am Unable to access the Power BI Copilot feature. Could you kindly guide me on how to access/use Copilot in Power BI? Are there any institutes in Hyderabad-India that have copilot license?
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
can you please upload the video for, if we cannot choose any filter then it that report table should be showed No Data available . Once we choose the Filter then data showed and in the Filter if we choose any one of the year that specific year have no data then also it showed no data pls choose another filter (like custom message)
Challenge With sample Global superstore as dataset, Can we have top 5 returns by priority and city in a matrix or table table with year as first column with no repeats, second column as market. Product name Order Priority Country
That is awesome tricks ❤ The challenge I have , how do you make that sorting arrow disappear from the table all together? User doesn’t want to see sorting arrow , I have no answer for that . Can you please help me ?
In that case you can use a rank measure which will give Ranking based on your criteria and you can hidden that measure in the same table and matrix visual. That shorting of the table will be based on your rank measure.
📌My Top 5 Power BI Mistakes (and how to avoid them) - ua-cam.com/video/ZIbK5MuLSfM/v-deo.htmlfeature=shared
⬇Download the file - goodly.co.in/power-bi-visualization-tricks
📊Interested in tackling tough problems in Power BI? Enroll in my DAX and Data Modeling course today - goodly.co.in/learn-dax-powerbi/
Ive been using Power BI for about 8 years and I learned a few new tips! Thank you!
Awesome Chandeep! Number 10 was the best
Thanks a lot, your videos are always very helpful.
Thank you!!! Very informative 😊
Fabulous insights and tricks ; your videos are so crisp and so knowledgeful; thank you for sharing
Enrolled for your course 😊 your way to explain things is super easy to understand and soothing
Great stuff as always! Thanks
Excelente tutorial. Enhorabuena y muchas gracias.
Amazing , thank you
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 .
Thank you 🙏
Great tips!
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
Trick No 10 is very interesting
Classic and saves tons of time
awesome, trick 10 top the chart
Impressionante como pode ter tantas dicas em um só vídeo #powerbinareal
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.
googleusercontent.com/youtube_content/1
Thank you
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.
It just changed on my powerbi too. Before it was on the row header now this setting moved to the style preset. Very confusing...
Field Parameters took me off guard. Thanks for explaining this useful feature.
Pivot Table Classic Layout (putting nested rows beside top row content) -> 0:51
Great
Is it possible 2 Likes? This is very good, even knowing the tool!! Thanks Chandeep!!
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"
Hi Sir, I am Unable to access the Power BI Copilot feature. Could you kindly guide me on how to access/use Copilot in Power BI? Are there any institutes in Hyderabad-India that have copilot license?
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
I cannot find "Stepped layout" It seems that it is gone. What has this been replaced with in Power BI?
Number 10: once you selected a Region (New Delhi) and switch back to Channel, hope the selection will remain the same in the TABLE
Hi, can you make a video on how to highlight selected column based on slicer with calculation group?
How do you draw over the screen with mouse?
Hi, could you make some video related to Deneb visual
1:20 it's not weird, it's detailed! It is not tableau - there are weird.😄
can you please upload the video for, if we cannot choose any filter then it that report table should be showed No Data available . Once we choose the Filter then data showed and in the Filter if we choose any one of the year that specific year have no data then also it showed no data pls choose another filter (like custom message)
❤❤❤
For the last trick we can use Hirarchichal Slicer no need for that i guess
Sir plz continue making vdos on new DAX concepts. Your concepts are super osm in real world data analysis problems. Especially that context transition
Hi. How to change values in million to crore in visual called "Card (New)"
How many Power bi developers will be there in organisation? Startup, mid level and MNC
I have a trick, if your matrix totals won't move (top to bottom or vice versa), toggle Stepped Layout (off/on or on/off) and they will move.
Since May 2024 Update - stepped layout is not an option anymore, instead of them we can choose from 3 different layouts (Compact, Outline, Tabular)
Challenge
With sample Global superstore as dataset,
Can we have top 5 returns by priority and city in a matrix or table
table with year as first column with no repeats,
second column as market.
Product name
Order Priority
Country
Power BI isn't showing the stepped layout option. Now, it's showing Tabular option.
Somewhere I saw keyboard shortcut to enable search bar in a slicer.. Now I forgot it
OK, it's ctrl+F
That is awesome tricks ❤ The challenge I have , how do you make that sorting arrow disappear from the table all together? User doesn’t want to see sorting arrow , I have no answer for that . Can you please help me ?
In that case you can use a rank measure which will give Ranking based on your criteria and you can hidden that measure in the same table and matrix visual.
That shorting of the table will be based on your rank measure.