Table / Matrix Visual Customization for better visiblity

Hi GanesaMoorthyGM, a couple notes on your current table:

• Less is more. the current color choices are quite distracting and make it very difficult to absorb any information. Reduce the amounts of colors to the absolute minimum required to get any information across.
  • I would recommend to change the alternating row colors to white + a very pale gray (potentially even paler than the default alternating gray Power BI is set to, or the lightest hint of blue if that's required due to your corporate design guide). Depending on the number of rows you might even want to consider turning off the alternating colors completely.
  • Only use conditional formatting to highlight rows where you really want to point out rows that require action in some form and consider the color contrast of your background vs font-color. It might not be required but I'd recommend to aim for a ratio of 4.5:1 (= WCAG AA). It's amazing how much less a correct color ratio strains your eyes! You can check your color ratio with sites like this one https://webaim.org/resources/contrastchecker/ 
• Change the visual to a Matrix, set LocationCode, FiscalYearcode and monthName as "Rows", Cluster as "Columns" and your Measures (Stock Qty, Stock WT, Stock Value [...]) as "Values".

Your current table:

As a matrix:

Try these recommendations and feel free to let me know if you need any  more help!

Did this answer your question? If so, please consider marking it as the ‘Accepted Solution’ - it helps others with the same issue find the answer more easily.

Hi GanesaMoorthyGM ,

You need to place the Cluster in the columns of the matrix this will make the levels has you need  so you will get the location and years on the rows and the measure will be split by the different columns.