Tech blog with tips, tricks and hacks
for EVs, hardware, software, home automation, programming and more
If you’re working with data in Power BI and would like to count how many duplicates there are, the below example will help you. Let’s start with the table structure. For this example, lets says we want to see how many people have the same first name, and the data looks like this: EmployeeID FirstName
If you need to test something, but don’t want to risk changing or damaging your existing Windows installation, then you can utilise something called Windows Sandbox. This basically creates an isolated sandbox machine, which is automatically disposed of when you’re done with it. To get started, follow the below guide: Windows Sandbox Requirements For Windows
If you have a column containing numeric values in your Power BI report, depending on the graph, it can sometimes be too much and produce some messy graphs, like the below: To make this look better, you might want to group the data into ranges instead, to make it easier to read. For example, if