Forum Discussion
Solved
Top 5 across months (Matrix Visual)
Hello,
I need to show Top 5 Product sales by Month in Matrix visual as shown below.
I have created a measure Total Sales = SUM(Tables(amount)) presented as value in Matrix Visual
I have a month as a Columns in Matrix Visual
Product as Rows in Matrix Visual.
I need to show Top5 product sales by each month as shown below in a single Matrix Visual. Your help is appreciated.
sabeensp -
Have you taken a look at https://www.sqlbi.com/articles/filtering-the-top-3-products-for-each-category-in-power-bi/? Seems to be close to what you are trying to accomplish.
1 Reply
sabeensp -
Have you taken a look at https://www.sqlbi.com/articles/filtering-the-top-3-products-for-each-category-in-power-bi/? Seems to be close to what you are trying to accomplish.