Line chart with gradient color in Excel
If you have a data set with certain characteristics, you might want to take a chance and create a line chart with gradient…
Latest Posts
Reader PicksAll posts
Line chart with gradient color in Excel
If you have a data set with certain characteristics, you might want to take a chance and create a line chart with gradient…
How to get when a file is created or modified in R
Here is how to get information when the file is created or modified in R. With help of R, you can extract this…
Year and month combination in R
The year and month combination in R is possible in different ways. In my case, it is a combination in one data frame…
Switch Power BI chart axis dimensions
Here is a solution to add more analytical capabilities to your Power BI charts. Switch Power BI chart axis dimensions to get data…
How to calculate weighted average using DAX in Power BI
Here is how to calculate weighted average using DAX in Power BI. By creating a measure that calculates the weighted average, you can…
Replace values in the entire R data frame or range of columns
Sometimes data frames or a wide range of columns might contain values that you want to remove or replace. Here is how to…
3 ways how to create OR logic in DAX
OR logic in DAX is frequently used in various Power BI calculations. The bad and the good news is that you can create…
Export data from R to Excel
Here is how to export data from R to Excel. If you want to write an R data frame in an xlsx file,…
Top 6 Excel advanced filter tips and tricks
Here are my top 6 Excel advanced filter tips and tricks. It is a great tool to speed up and optimize filtering processes…
How to filter by data frame row number in R
RStudio data viewer is a great tool to look into data, but sometimes it is necessary to filter by data frame row number…