Here is a simple solution to create a five star rating in Excel using formulas or Power BI using DAX. The result is obtainable using only Excel formulas or DAX capabilities. You can do that with other symbols or emojis too. With the same techniques, it is possible to create a progress bar in Excel… Continue reading Create star rating in Excel or Power BI using DAX
Category: Excel DataViz
Jitter chart in Excel with average line
A jitter chart in Excel is a beautiful way to use a scatterplot and randomly distribute data points to make them more visible. In other words, if your problem is overlapping data points in Excel, this might be a good solution.