Did you know you can adjust the page size of your reports in Power BI? Each tab/page of your report can be a unique size specified by you down to the pixel. This comes in handy for creating “widget-like” visuals for embedding or for creating reports for print and optimal display on various screen sizes. Read More
Category: Microsoft Family
Microsoft Windows Servers, AD, Exchange, Azure, Windows 10, Office 365 and more
What is the Difference Between INNER JOIN, LEFT JOIN, RIGHT JOIN and FULL JOIN?
There are different types of joins available in SQL: INNER JOIN: returns rows when there is a match in both tables. LEFT JOIN: returns all rows from the left table, even if there are no matches in the right table. RIGHT JOIN: returns all rows from the right table, even if there are no matches Read More
How to Fix Total Row is Displaying 0 Instead of Real Sum
Sample problem: I have employee data, which I used to create a table with headcounts and a measure of % Female: The tricky part is when I want a count of how many countries have % Female >= 30%. I added a measure: Meets Criteria = IF ((Female HC]/ [Total HC]) >= 0.3, 1, 0) It Read More
How to Set up Alerts in the Power BI
Set alerts to notify you when data in your dashboards changes beyond the limits you set. You can set alerts on tiles in your My Workspace. You can also set alerts if someone shares a dashboard that’s in a Premium capacity. If you have a Power BI Pro license, you can set alerts on tiles in Read More
How to Remove Duplicates by Using Power Query for Excel
Open up the Power Query Editor. Go to Home > Remove Rows > Remove Duplicates STEP 4: Click Close & Load from the Home tab and this will open up a brand new worksheet in your Excel workbook with the cleaned table. You now have your new table with the remove duplicates power query! This completes our tutorial on How to Remove Duplicates Read More
How to Fix the Problem of “A circular dependency was detected”
A circular dependency is detected whenever two objects reference each other, in such a way that Power BI cannot process the objects. The details of why this happens are outlined in this article: Understanding Circular Dependencies in Tabular and PowerPivot – SQLBI. Here, the focus is solely on what to do to solve the scenario. We Read More