Getting viable data from an Excel workbook into Power BI for data visualization purposes takes some specific preparation. Here is what you need to do.

Learn how to add visual insight to data by applying conditional formatting to a table or matrix visualization in Microsoft Power BI.